I’ve just installed 1.4 to a machine and as I understand it, it
installs with one user, ‘root’@‘localhost’.
In phpMyAdmin, I see that the config.inc.php file, I can see this is
specified – root, no password, localhost (and I tried 127.0.0.1 as
well).
However, when I go into phpMyAdmin (from configure- database (via
phpMyAdmin) I get:
#1045 - Access denied for user ‘root’@‘localhost’ (using password: NO)
Similarly, if I try going into MySQL, I get:
C:\InstantRails\mysql\bin>mysql
ERROR 1045 (28000): Access denied for user ‘ODBC’@‘localhost’ (using
password: N
O)
C:\InstantRails\mysql\bin>mysql -u root
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using
password: N
O)
Now, all I am trying to do is set up a new user by submitting the
following commands:
grant all on . to ggrip@’%’ identified by “xfiles”;
flush privileges;
set password for ggrip@’%’=OLD_PASSWORD(‘xfiles’);
flush privileges;
My problem is, I cannot get into the database no matter what I seem to
do – it wont seem to recognise root with no password on localhost. Can
someone please tell me what I am doing wrong here. Thanks.