Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 11-09-2009
Member
 
Join Date: Jul 2009
Posts: 104
What is the mysql default password ?

Hi,

I have installed MAMP and it automatically gave me root and root. I am using WAMP. I went to login to the mysql database server admin through the webmin interface. It asks for a username and password. What is the default mysql password, and how can i change it to my own?
Reply With Quote
  #2  
Old 11-09-2009
Member
 
Join Date: May 2008
Posts: 260
Re: What is the mysql default password ?

The initial default Mysql password is blank. The default password depends on distribution. when you created the mysql database, you need to add database user to this database, this user login will be the 'password' that you need.
Reply With Quote
  #3  
Old 11-09-2009
Member
 
Join Date: May 2008
Posts: 390
Re: What is the mysql default password ?

One of the first things they recommend is to set a new root password and run the Grant table which controls access to the Database. The grant tables define the initial MySQL user accounts and their access privileges. If you want to chnage the system root password, you have to do that through phpMyAdmin's Administration Interface.
Reply With Quote
  #4  
Old 11-09-2009
Member
 
Join Date: May 2008
Posts: 181
Re: What is the mysql default password ?

The default mysql user is root and the password is blank.

You can set your own root password by typing :

Code:
# mysqladmin -u root password 'new-password'

Then login by typing this:

Code:
# mysql -u root –p
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is the mysql default password ?"
Thread Thread Starter Forum Replies Last Post
Change default port no for mysql in XAMPP nachiket Software Development 3 28-12-2009 03:42 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Recover lost mysql password sam007 Software Development 2 20-08-2009 02:45 PM
How to reset mysql password? Yarn Software Development 2 23-05-2009 06:04 PM
How to change password in MySQL? Tweaker Software Development 2 20-10-2008 04:47 PM


All times are GMT +5.5. The time now is 12:30 PM.