Why does this normal syntax does not work here.....
mysql> show grants for root@'%';
ERROR 1141 (42000): There is no such grant defined for user 'root' on host '%'
mysql> show grants for 'root'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'root' on host '%'
Jenk, try to understand, in my other topic I have replied, I am just doing this to understand mysql in depth and I am not running any kind of website from here.
If anything goes wrong, I do not mind reinstalling mysql again....
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select version();
+------------+
| version() |
+------------+
| 4.0.25-log |
+------------+
1 row in set (0.00 sec)
mysql> show grants for root@'%';
+-------------------------------------------------------------------------------------------------------+
| Grants for root@% |
+-------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '<censored>' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show grants for 'root'@'%';
+-------------------------------------------------------------------------------------------------------+
| Grants for root@% |
+-------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '<censored>' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
you may try to delete users directly from mysql.user table (issue FLUSH PRIVILEGES after that). There are chances you'll get more meaningful error message.
I have now come up with this problem. I searched in devnetwork.net, there is no exact solution given for the same problem. I appreciate any kind of guidance.
This happened after I tried to stop the mysql in command prompt and tried to alter a mysql server instance. As far as Windows services, mysql is running
C:\>mysql -u root -p
Enter password: ************
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
C:\>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306.
No connection could be made because the target machine actively refused it.
The mysql 5 installation reported tcp port 3306 may be refused. I tried something with McAfee and it worked.
I copied my database folder in mysql4-install-dir/data and pasted in mysql5-install-dir/data and I am able to work with my old databases in mysql 4.