bookmark

What Is Mysql's Default Root Password? - Just installed in on my Linux box

 
 Discussion by michaelper22 with 11 Replies.
 Last Update: January 2, 2010, 1:41 pm ( View 5 ) (View Latest)
Page 1 of 2 pages.
bookmark  

 
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?

Wed Dec 28 16:56:53 PST 2005 - Reply -   

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.

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.

Wed Dec 28 18:47:13 PST 2005 - Reply -   

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

Thu Dec 29 2:14:34 PST 2005 - Reply -   

Thu Dec 29 6:43:01 PST 2005 - Reply -   

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

You can set the root password by typing this:

CODE

# mysqladmin -u root password 'new-password'


You can then login by typing this:

CODE

# 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:

CODE

# mysql -u root –p

mysql> use mysql

mysql> delete from user where User='';

mysql> quit

Thu Dec 29 10:25:42 PST 2005 - Reply -   

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?

Thu Oct 25 6:48:57 PDT 2007 - Reply -   

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

Sat May 24 1:58:10 PDT 2008 - Reply -   

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

Wed May 28 8:56:41 PDT 2008 - Reply -   

Try stopping the mysql daemon

CODE

/etc/init.d/mysql stop

Run

CODE

mysqld_safe --skip-grant-tables &

Enter as root

CODE

mysql -u root -p


To change root password

CODE

mysql client - mysql -u root

and write

CODE

use mysql

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

Fri Jun 13 13:01:19 PDT 2008 - Reply -   

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

Tue Sep 2 21:20:05 PDT 2008 - Reply -   

Reply / Comment New Discussion / Topic Share / Bookmark E-Mail a Friend Print


Default settings for mysqlWhat Is Mysql's Default Root Password?

I m using ubuntu and I have downloaded mysql query browser what is  server host name, username, password and port number. I have tried host name as localhost, username as root and password as blank and port number 3306. But I m getting error Could not connect to host 'localhost'.MySQL Error Nr. 2002Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.Sock' (2).

 Can anyone help me?

more

Tue Mar 2 0:08:10 PST 2010 - Reply -   

Default Mysql login details for Windos VPS serverWhat Is Mysql's Default Root Password?

Hi everybody,I have recently transferred from shared hosting to virtual private server.And when moving my database to a newserver (VPS) I was unable to Login to Mysql or PhpMyAdmin.Iam using Login: root (which is unix SSH login)Pass: password for ( Unix SSH access)Can anyone tell me how to login to mysql or phpmyadminOr where the configuration file will be?Waiting for replies

Saiful

  ...more

Sat Jan 2 13:41:43 PST 2010 - Reply -   

   What Is Flash? (12) (16) Connect To Remote Oracle Database With Toad i'm lost  


  

 

Honesty ROCKS! truth rules.