Default usernames and passwords for mysql server 5

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 17.10.2006 20:29:36 von unknown

Post removed (X-No-Archive: yes)

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