Results 1 to 4 of 4

Thread: What is the mysql default password ?

  1. #1
    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?

  2. #2
    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.

  3. #3
    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.

  4. #4
    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

Similar Threads

  1. Change default port no for mysql in XAMPP
    By nachiket in forum Software Development
    Replies: 3
    Last Post: 28-12-2009, 03:42 PM
  2. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  3. Recover lost mysql password
    By sam007 in forum Software Development
    Replies: 2
    Last Post: 20-08-2009, 02:45 PM
  4. How to reset mysql password?
    By Yarn in forum Software Development
    Replies: 2
    Last Post: 23-05-2009, 06:04 PM
  5. How to change password in MySQL?
    By Tweaker in forum Software Development
    Replies: 2
    Last Post: 20-10-2008, 04:47 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,621,931.98747 seconds with 17 queries