how to secure MySQL
Posted by: john (216.100.89.---)
Date: February 10, 2006 10:56PM

hey i dont kno how to set the passwords and or create mysql user accounts any one know of any tutorials or anything to help out.

Re: how to secure MySQL
Posted by: Robert (---.eburwd3.vic.optusnet.com.au)
Date: February 10, 2006 11:37PM

Easy.

Open phpMyAdmin from your WAMP icon.
Click on [Privileges].
Click the "Edit" Icon for Root (far right end - pencil icon)
Scroll down to "Change Password"
Enter your desired Root password
Click in the [GO] box.

Your Root access for MySQL is now passworded.
Note that now phpMyAdmin does not know how to access your MySQL server.

Go to c:\wamp\myphpadmin\
Open config.inc

Find the line $cfg['Servers']['$i']['Password'] = ''

Enter your Root Password in between the last two quotes.

You should now have $cfg['Servers']['$i']['Password'] = 'yourpassword'

Save the config.inc file.

Now phpMyAdmin should let you back in to MySQL

Sorry, only registered users may post in this forum.