At 1:53 -0400 6/14/03, John Chang wrote:
It worked!!. Thanks. Now how do I protect it so that not anyone who points to it cannot get to it without putting in a username/password?

You seem to have an odd set of goals.


First, you want to remove the password from your MySQL root account.
That is, you want to remove the protection against unauthorized access.

Next, you want to keep people from getting to it without a password.
That is, you want protection against unauthorized access.

I fail to understand what you're trying to achieve...


At 12:24 AM 6/14/2003 -0500, John Nichel wrote:
John Chang wrote:
I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser.
What do I need to change? Thanks.


Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote:

At 0:10 -0400 6/14/03, John Chang wrote:

How do I set no password for root?


mysql -u root -p
Enter password: (your current root password here)
mysql> SET PASSWORD = '';
mysql> quit


-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/

If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there.


With that being said, why would you want an empty root password????


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to