Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Nov 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to change mysql root password

    i downloaded the phpdev423 bundle from
    http://www.firepages.com.au/phpdev41.htm

    after installed it, i understand that by default, MySQL has no security. I just want to know how to change the root password? What should i do to secure the server if it's connected to the internet, to prevent it being compromised by hackers?

    can anyone give me a step-by-step guide on how to configure the settings to make it more secure?

    Thanks in advanced.

  • #2
    New to the CF scene
    Join Date
    Nov 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    First of all you should remove the anonymous user from mySQL by logging into mySQL then running this sql:

    mysql> DELETE FROM user WHERE host='localhost' AND user='';

    Quit mySQL and from the command line run the following (make sure you are in the mysql\bin directory):

    mysqladmin reload

    This reloads all the table information and therefore removing the anonymous user.

    Next, still in the command line:

    mysqladmin -u root password <your new password>

    This sets a password for the root user (admin) and your job is done

    If you wan to see the priveleges set for user, db's and tables then simply view the tables in the mysql database with so sql:

    e.g. select user,host from users;

    Hope this helps you - JaYsuN


  •  

    Posting Permissions

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