> 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
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 i
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?
-
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,
TED]>
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!!.
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
Ni
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 c
2: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: &#
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/1
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
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
How do I set no password for root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
12 matches
Mail list logo
