Hello - Im trying to change the root password on a new mysql installation. Im running 4.1.1a-alpha on WindowsXP with Apache running.
I get the error below saynig access denied. How do I get into the user table as root if It wont allow me into the database? Any help would be appreciated. C:\mysql\bin>mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.1.1a-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select database(); +------------+ | database() | +------------+ | NULL | +------------+ 1 row in set (0.00 sec) mysql> connect mysql ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'mysql' mysql>