MySQL Help
Results 1 to 6 of 6

Thread: MySQL Help

  1. #1
    Banned
    Join Date
    Oct 2001
    Posts
    1,462

    MySQL Help

    Does anyone know the command to set the password for the root user (new install) and start the server?

  2. #2
    Junior Member
    Join Date
    Aug 2001
    Posts
    17
    Hi ac1dsp3ctrum,

    Which version of MySQL are you using? Windows or Linux?

    If you're using for windows you can set the root/administrator password after installation by going to the directory / folder where you have installed MySQL.

    Proceed to the bin folder and double-click winmysqladmin.exe it will ask you for the username and password of the administrator, and it will automatically load MySQL afterwards.

    Hope this helps.

  3. #3
    Senior Member
    Join Date
    Nov 2001
    Posts
    119
    hope this helps as well:

    http://www.mysql.com/doc/D/e/Default_privileges.html

    cheers,
    the only thing that doesn\'t change is everything will always change.

  4. #4
    AntiOnline Senior Member souleman's Avatar
    Join Date
    Oct 2001
    Location
    Flint, MI
    Posts
    2,884
    http://www.codebits.com/bit.cfm?BitID=120


    http://www.mysql.com/doc/D/e/Default_privileges.html gives you....
    shell> mysql -u root mysql
    mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password');
    Hope something there helps....
    \"Ignorance is bliss....
    but only for your enemy\"
    -- souleman

  5. #5
    Jaded Network Admin nebulus200's Avatar
    Join Date
    Jun 2002
    Posts
    1,356
    from install :
    You should also add a password for the `root' user. The following
    example starts by removing the anonymous user that can be used by anyone
    to access the `test' database, then sets a `root' user password:

    C:\> C:\mysql\bin\mysql mysql
    mysql> DELETE FROM user WHERE Host='localhost' AND User='';
    mysql> QUIT
    C:\> C:\mysql\bin\mysqladmin reload
    C:\> C:\mysql\bin\mysqladmin -u root password your_password

    After you've set the password, if you want to take down the `mysqld'
    server, you can do so using this command:

    C:\> mysqladmin --user=root --password=your_password shutdown


    * Use passwords for all MySQL users. Remember that anyone can log in
    as any other person as simply as `mysql -u other_user db_name' if
    `other_user' has no password. It is common behavior with
    client/server applications that the client may specify any user
    name. You can change the password of all users by editing the
    `mysql_install_db' script before you run it, or only the password
    for the MySQL `root' user like this:

    shell> mysql -u root mysql
    mysql> UPDATE user SET Password=PASSWORD('new_password')
    WHERE user='root';
    mysql> FLUSH PRIVILEGES;


    Because your installation is initially wide open, one of the first
    things you should do is specify a password for the MySQL `root' user.
    You can do this as follows (note that you specify the password using
    the `PASSWORD()' function):

    shell> mysql -u root mysql
    mysql> UPDATE user SET Password=PASSWORD('new_password')
    WHERE user='root';
    mysql> FLUSH PRIVILEGES;


    Neb
    There is only one constant, one universal, it is the only real truth: causality. Action. Reaction. Cause and effect...There is no escape from it, we are forever slaves to it. Our only hope, our only peace is to understand it, to understand the 'why'. 'Why' is what separates us from them, you from me. 'Why' is the only real social power, without it you are powerless.

    (Merovingian - Matrix Reloaded)

  6. #6
    Jaded Network Admin nebulus200's Avatar
    Join Date
    Jun 2002
    Posts
    1,356
    Attached is Install file (compressed)
    There is only one constant, one universal, it is the only real truth: causality. Action. Reaction. Cause and effect...There is no escape from it, we are forever slaves to it. Our only hope, our only peace is to understand it, to understand the 'why'. 'Why' is what separates us from them, you from me. 'Why' is the only real social power, without it you are powerless.

    (Merovingian - Matrix Reloaded)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •