, the root user
password has already been set, so if the MySQL server sees the
second command as an attempt to set the 'root'@'localhost' password,
it will fail because you're not authenticated.
Now, I experimented some more on different machines, and on some
machines, the second command gives
been set, so if the MySQL server sees the second command
as an attempt to set the 'root'@'localhost' password, it will fail
because you're not authenticated.
Now, I experimented some more on different machines, and on some
machines, the second command gives an error and on other machines
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
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
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
-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
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
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
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]
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
, 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
/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
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
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
Description:
Trying to set the mysql root password using the command line given
results in a permissions error connecting to the database @localhost.
How-To-Repeat:
Cd to my home directory, and execute:
./usr/local/mysql/bin/mysqladmin -u root password 'anypassword'
Fix:
Unknown
Submitter-Id
15 matches
Mail list logo