Messed up my.cnf file Help me guys

[0ccul7]

Damn

[NewEraCracker]

Just a question which is the default storage engine?

Edit:

1. Open mysql in ssh:

mysql -u root -p

2. Supply the MySQL root password

3. Run:

SHOW VARIABLES LIKE 'storage%';

And paste output here.

[kos]

how to know that bro ?

[kos]

Is this a new problem i got error bro
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[NewEraCracker]

Is this a new problem i got error bro
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Hehe. Your MySQL root password differs from the ssh root password.

Dig on that later. Use the account you used for the commands to check the database.

[kos]

Strange i tried all passwords which i have even though i am getting same error bro any other alternative way to retrieve storage engine ?

[NewEraCracker]

ok. lets say your username is 'username', to open mysql in ssh do:
mysql -u username -p
and supply the password.
Then run the cmd I told you

Anyway. A quick look to the issue shows me that vBulletin is a big fail like Xenforo.
It sets engine to INNODB even when it is not the default engine WITHOUT asking the user 1st!

[kos]

+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | MyISAM |
+----------------+--------+
1 row in set (0.02 sec)

Heheheh yeah bro understood u now . Will u please optimize my.cnf file bro

this is my present my.cnf file

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 1000M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

[mysqldump]
quick
max_allowed_packet = 2000M

[mysql.server]
user=mysql

[mysqld_safe]
open_files_limit = 8192
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

[NewEraCracker]

May I know which is your MySQL version?

[kos]

ur plugin results
You are running MySQL 5.0.92, please ask your host to upgrade to MySQL 5.1!