Re: unable to create database even as root user

[siva balan]

hello james,

i have posted the entire things..please have a look.


[root@localhost]# mysqld_safe --skip-grant-tables &

[1] 14144
[root@localhost]# 120303 16:01:47 mysqld_safe Logging to '/var/log/mysqld.log'.
120303 16:01:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[1] 14144

[root@localhost]#mysql -u root

mysql>GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'abcd' WITH GRANT OPTION;

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement