Default usernames and passwords for mysql server 5

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
Gonzosez [ Di, 17 Oktober 2006 18:39 ] [ ID #1503697 ]

Re: Default usernames and passwords for mysql server 5

>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
Peter [ Di, 17 Oktober 2006 19:57 ] [ ID #1503698 ]

Re: Default usernames and passwords for mysql server 5

Post removed (X-No-Archive: yes)
Notifier Deamon [ Di, 17 Oktober 2006 20:29 ] [ ID #1503699 ]

Re: Default usernames and passwords for mysql server 5

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
tito [ Mi, 18 Oktober 2006 03:55 ] [ ID #1505172 ]
PHP » alt.php.sql » Default usernames and passwords for mysql server 5

Vorheriges Thema: Help in keep records while updating the records
Nächstes Thema: Job Senior PHP 5 Web Developer - NYC