11 replies to this topic

[michaelper22]

I installed SuSE Linux 9.1 Professional on an old computer recently. I installed MySQL server (version 4.0.18), Webmin (version 1.250) and Usermin (version 1.180). If I try to connect to the MySQL server with the username root and no password, I get an invalid login error from Webmin, Usermin and mysql-cc. What is the default password, and how can I change it? I am very excited to be learning Linux (after a long journey through Windows-land), but get frustrated on loopholes like these.
Also, an a different note, why would the system stop loading after a certain point (towards the end, don't remeber where) if I have my USB drive plugged in before booting?

[jlhaslip]

The initial Mysql password is blank according to this info for mysql ver 5.0. YOU WILL HAVE TO READ THE MANUAL FOR YOUR SPECIFIC VERSION. One of the first things they reccomend is to set a new root password and run the Grant table which controls access to the Database.

Quote

After a fresh installation, you should connect to the server and set up your users and their access permissions:

shell> mysql -u root mysql
The server should let you connect because the MySQL root user has no password initially. That is also a security risk, so setting the password for the root accounts is something you should do while you're setting up your other MySQL users. For instructions on setting the initial passwords, see Section 2.9.3, “Securing the Initial MySQL Accounts”.

The manuals are available at mysql.com either for online reading or by downloading. If you have installed it locally, probably best to download it.

Hope this helps.

[OpaQue]

Try "su" as username and password is "" (blank).

[Inspiron]

I'm not sure about MySQL but I guess you can get some references here..
http://dev.mysql.com...rd-hashing.html
http://www.experts-exchange.com/Databases/...Q_20678779.html

[leiaah]

The default user is root and the password is, as they say blank for default.

You can set the root password by typing this:

# mysqladmin -u root password 'new-password'

You can then login by typing this:

# mysql -u root –p 

Then you'll be prompted to provide the password you specified earlier.

You also might want to delete the anonymous user in the User's table. The default configuration of MySQL allows any user access to the system without
providing a username or password.

Delete the user by typing this:

# mysql -u root –p
mysql> use mysql
mysql> delete from user where User='';
mysql> quit

[iGuest]

I've changed the password with:

mysqladmin -you root password foo

When I run:

mysql -you root �p and enter foo when prompted, I get:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Ideas?

[iGuest]

how to establish mysql database connection with php code
What Is Mysql's Default Root Password?

Hi,I have installed easy php1.8 on to my system and I created a database and tables in it.I'm trying to send the form data written in html to my database using php code.I'm getting errors like

Access denied for user@localhost using password (yes)

Here I didnt used any username or password or it was not asked during installation.So,because of the above error I'm unable to connect to the database.Hence I'm unable to send the form data tomy database table.I dontknow whether there may be any default passwords or not.

Please help me out

[iGuest]

Same problem with my mysql installation
What Is Mysql's Default Root Password?

Replying to Trap FeedBacker

Even I just installed my mysql. It dint prompt for any password when it was installed nor did the blank password work. It returs with the same error when I try to open sql or try to change the password... Any help?

-reply by Rajaram

[Framp]

Try stopping the mysql daemon

/etc/init.d/mysql stop

Run

mysqld_safe --skip-grant-tables &

Enter as root

mysql -u root -p

To change root password

mysql client - mysql -u root

and write

use mysql
 update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

[iGuest]

Yes!!!
What Is Mysql's Default Root Password?

Replying to Framp
Dude I've been searching for an answer ALL DAY LONG! Thank you so much this helped tons!

-reply by Drew