At 12:17 PM 1/22/2004, Patrick Shoaf wrote:
Once you've added a root passsword you'll need to add this to the config.inc.php (assuming you're running phpMyAdmin with conf option; the default behaviour) then reconnect to phpMyAdmin
* * * * * * * * * *
OK, I found the config.inc.php file, along with a
tutorial at
<http://www.aota.net/PHP_and_MySQL/phpmyadmin.php4>http://www.aota.net/PHP_and_MySQL/phpmyadmin.php4
It's an installation tutorial, but it looks like it can be applied to changing passwords, too.
So it looks like I need to do the following:
1. Access the phpMyAdmin program configuration file. Are you referring to the page I get when I click Privileges, which lists all users, then I click "Edit" after Root/Local? It has a function named "Change Password," but since I don't have a root password, I would go to "Change Login Information," right?
If so, which of the four choices should I choose under
"Create a new user with the same privileges"? (I put a
screen shot online at
<http://geowebworks.geobop.org/mysql/2.php;>http://geowebworks.geobop.org/mysql/2.php; it's the
last picture on the page.)
2. Follow the following instructions
Change Login Information / Copy User
2) when changing the password for root, make sure you have access to the phpMyAdmin program configuration file. You will need to set the new root password there, or configure phpMyAdmin to ask for the username/password.
a. Create a password for User (Root), Host (localhost). I'm using "holiday" as an example for my password. b. Then open the config.inc.php file and change these two lines...
$cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] =''
to:
$cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] =''holiday
* * * * * * * * * *
However, there's apparently an alternative method, that may be better. Would you recommend Plan 2 (above), or one of the following (http or cookie)? Again, I'm the only administrator and user of MySQL on my computer, but I'll be publishing websites to the Internet:
http or cookie authentication methods - These methods are more secure, as your username and password are not stored on the server in your configuration file.
To use either of these methods, find the first occurrence of the following two lines in the config.php.inc file:
$cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] =''
And change them to:
$cfgServers[$i]['user'] = ''; $cfgServers[$i]['password'] =''
Providing neither your password nor your username. Next, locate the first occurrence of the following line:
$cfg['Servers'][$i]['auth_type'] = 'config';
And change it to either
$cfg['Servers'][$i]['auth_type'] = 'http';
or
$cfg['Servers'][$i]['auth_type'] = 'cookie';
3. Reload the Privileges. (This is sort of like refreshing a page, and, if I'm not sure whether it needs to be done, I can do it anyway, as many times as I want, right?)
4. Do I need to restart my computer before the changes will take effect?
Thanks!
Password are a very funny issue. When adding users & allowing access to databases & table, you have to be very careful, as you found out, you can break things quickly.
Here are a few items to help you... 1) after adding a new user, on the privileges page, try issuing a reload (very last line on the page has a link). You need to reload, flush, the users table to make users visible to the world. 2) when changing the password for root, make sure you have access to the phpMyAdmin program configuration file. You will need to set the new root password there, or configure phpMyAdmin to ask for the username/password. 3) DreamWeaver will access the mySQL using root with no password, but that is frowned on by all. Anyone would have full access to mySQL and be able to create havoc for you. 4) If an ISP is hosting you MySQL data, then you will be issued usernames/passwords to access MySQL, most ISP's do not provide you a dedicated MySQL Server with root access.
