Default usernames and passwords for mysql server 5
am 17.10.2006 18:39:23 von Gonzosez
I am on win98se, when installing mysql server 5 I did not get a prompt to
setup a root user and a root password, even with detailed configuration, I
assume there is a default root user and default root password, does anyone
know what it is?
thanks
Re: Default usernames and passwords for mysql server 5
am 17.10.2006 19:57:40 von Peter
>I am on win98se, when installing mysql server 5 I did not get a prompt to
> setup a root user and a root password, even with detailed configuration, I
> assume there is a default root user and default root password, does anyone
> know what it is?
as per the following manual page the username is root and the password is
empty (not the word empty just doesnt exist)
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.ht ml
Re: Default usernames and passwords for mysql server 5
am 18.10.2006 03:55:57 von tito
I found inserting a root password using phpMyAdmin priveleges was
buggy.
So, I recommend using the old fashioned way.
If you can access MySQL in DOS ...
cd \mysql\bin
mysql -u root mysql
Otherwise you can use the SQL section of phpMySQL ...
UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE user='root';
FLUSH PRIVILEGES;
QUIT