Re: Set no root password
> Simply I didn't know where the password was located in myphpadmin. The password is not in myphpadmin. It is in the database. Log in as root and look at the "mysql" database. Also, read sections 4.2 and 4.3 of the MySQL manual. > I > wanted it secure but I wanted to be able to get to the data with myphpadmin > too. But now I know where it is I put the password in. And now I want to > protect phpmyadmin so that only folks with a username/password can access it. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
Simply I didn't know where the password was located in myphpadmin. I wanted it secure but I wanted to be able to get to the data with myphpadmin too. But now I know where it is I put the password in. And now I want to protect phpmyadmin so that only folks with a username/password can access it. At 10:43 AM 6/14/2003 -0500, you wrote: 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/
Re: Set no root password
I think I have figured out what he wants: He wants to set a root password (randomly) and then save it in ~root/.my.cnf so that the root user doesn't (apparently) need a password to log into MySQL. However, any other user trying to log in as root would need to know the password. Am I close? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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]
Re: Set no root password
> You saved my day. Haven't laughed like this for long time ;-) Seriously. I wish I was drinking more earlier so as to fully appreciate this one. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "John Chang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, 14 June, 2003 02:12 Subject: Re: Set no root password Hi John, You saved my day. Haven't laughed like this for long time ;-) >How do I set no password for root? > 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? Thanks a lot really. Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 14:53、John Chang さんは書きました: > 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? > > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
Hi John, You saved my day. Haven't laughed like this for long time ;-) >How do I set no password for root? > 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? Thanks a lot really. Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 14:53、John Chang さんは書きました: > 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? > > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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? 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
RE: Set no root password
Try 'mysqladmin flush-privileges' --cut-- flush-privileges Reload grant tables (same as reload) --end cut-- then login (been there... Stuck there too...) chris -Original Message- From: John Chang [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2003 12:17 AM To: [EMAIL PROTECTED] Subject: Re: Set no root password 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
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/
Re: Set no root password
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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]