Okay, that worked, thank you!
-Mike
On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote:
> On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson
> wrote:
>
>> I don't know what the password is for the Unix mysql user...
>>
>> You mean sign in as mysql in the OS X Login Window?
>
> Just open a term
Make sure your mysql server is not accessible to anyone else, its a good
idea to disconnect all network connections because the server will be
totally insecure for a short period of time!
Start your MySQL server with the --SKIP-GRANT-TABLES option.
At a shell prompt type
mysql -uroot
None, of these suggestions worked...
Tried the following ways to reset the password:
(1) Shut down MySQL via System Preferences pane
(2) Placed the following in a text file:
UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';
FLUSH PRIVILEGES;
(3 Invoked the following command from t
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson
wrote:
> I am running MySQL 5 on OS X Snow Leopard...
>
> Have it set up (by installing the pref pane) to always be running as
soon
> as my MacBook starts.
>
> For some odd reason, I can't remember the password I issued for "root"
> user and wis
blank or a new specific password.
What should I type from the command line?
When I tried:
http://lmgtfy.com/?q=mysql+reset+root+password
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I am running MySQL 5 on OS X Snow Leopard...
Have it set up (by installing the pref pane) to always be running as soon as my
MacBook starts.
For some odd reason, I can't remember the password I issued for "root" user and
wish to either change it back to blank or a new specific password.
What s
AM 9/15/2009, Bennett Haselton wrote:
When I install and start the MySQL server on a new machine, it outputs:
>>>
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-pass
When I install and start the MySQL server on a new machine, it outputs:
>>>
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u
dd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Monday, April 27, 2009 9:46 AM
To: mysql@lists.mysql.com
Subject: Resetting MySQL Root Password
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysql
On 4/27/09, Jason Todd Slack-Moehrle wrote:
> Hi All,
>
> CentOS 5.3
>
> I installed MySQL Server via yum and started it.
>
> I tried entering:
>
> mysqladmin -u root password yourrootsqlpassword
> mysqladmin -h server1.example.com -u root password yourrootsq
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
But I get:
r...@server1 ~]# /usr/bin/mysqladmin -u root -h localhost password
Dear List,
I have solved my problem I think.
For some reasons 'alias mysql=/usr/local/mysql/bin/mysql' didnt work for me.
When I type '/usr/local/mysql/bin/mysql -u root' I can log in as a root
and change password.
Later I can log in: '/usr/local/mysql/bin/mysql -u root -p'
Thank you,
Olga
Olga Lyashevska wrote:
e7253:mysql olichka$ /usr/local/mysql/bin/mysql
Try:
$ /usr/local/mysql/bin/mysql -u root -p
It looks like you aren't logging into MySQL as root, so you don't have
permission to set the root password. (If you don't give -u, it uses
your OS X
Dear List,
I have installed a binary package mysql-5.0.51a-osx10.5-x86_64.dmg
I can start up/shutdown MySQL and connect to MySQL server, but I cant
change a root password as required.
---begin example---
e7253:~ olichka$ cd /usr/local/mysql
e7253:mysql olichka$ sudo ./bin/mysqld_safe
On Saturday 01 March 2008 13:45, Jørn Dahl-Stamnes wrote:
> I have just installed MySQL 5. The server is running, but I'm not able to
> connect to the server as root.
>
> I have not set any root password, since I have not found any way to do this
> in version 5 (it was rathe
I have just installed MySQL 5. The server is running, but I'm not able to
connect to the server as root.
I have not set any root password, since I have not found any way to do this in
version 5 (it was rather good documented in version 4).
I have tried this solution to set the root pas
Johannes Skov Frandsen schrieb:
> Hi
>
> For reasons unknown my mysql db has decide to lock me out and I can't
> access it with my root account anymore from the shell.
>
> I have tried resetting it following this guide:
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
>
> but
Johannes Skov Frandsen schrieb:
> Hi
>
> For reasons unknown my mysql db has decide to lock me out and I can't
> access it with my root account anymore from the shell.
>
> I have tried resetting it following this guide:
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
>
> but
Hi
For reasons unknown my mysql db has decide to lock me out and I can't
access it with my root account anymore from the shell.
I have tried resetting it following this guide:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
but it doesn't seem to do the trick.
I just get
On Thursday 29 March 2007 11:38:21 Stephen Liu wrote:
> > http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
>
> I tried learning resetting the password according to above URL. I
> can't find "set" command on this box. I don't know which package
> provides it so finally I surrende
--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> So you *have* set the root password before.
>
> From your previous emails:
>
> # mysqladmin -u root password yourrootsqlpassword
>
> That set the password to "yourrootsqlpassword".
>
>
>
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart
> Stopping MySQL: [FAILED]
> Starting MySQL:[ OK ]
Ok, lets try it a different way, using only th
[EMAIL PROTECTED] ~]# mysqladmin -u root password xyz
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
* end *
So you *have* set the root password before.
From your previou
--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> Try this:
>
> mysqladmin -u root password xyz
>
> That will change your password to 'xyz'.
>
Before received this email I tried;
[EMAIL PROTECTED] ~]# mysqladmin -u root -p
mysqladmin Ver 8.41 Distrib 4.1.
.
[/quote]
I did not create password before. This is a new installation. I'm tuning
it.
Try this:
mysqladmin -u root password xyz
That will change your password to 'xyz'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Chris <[EMAIL PROTECTED]> wrote:
>
> > Retried as follows;
> >
> > [EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
> > Enter password:
> >
> >
> > Typing either "mypassword" or "YES" prompted;
>
ld* password.
[/quote]
I did not create password before. This is a new installation. I'm tuning
it.
Stephen Liu
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9728432
Sent from the MySQL - General mailing list archive at Nabble.com.
--
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either "mypassword" or "YES" prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'l
Hi Maciej,
I found that I made a mistake from the beginning
# mysqladmin -u root password yourrootsqlpassword
leaving out "--" before "password"
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either "mypa
d; log sequence number 0 436
34
070328 23:56:09 [Note] /usr/libexec/mysqld: Shutdown complete
070328 23:56:09 mysqld ended
* end *
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9717062
Sent from the MySQL - General mailing li
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables &
> [1] 5119
> [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
> /var/lib/mysql STOPPING server from pid file
> /var/run/mysqld/mysqld.pid 070328 19:39:12
Xorg.0.log.old
* end *
Read /var/log/mysql.log
Can't find anything related.
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9713069
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL Gene
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables &
> [1] 5119
> [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
> /var/lib/mysql STOPPING server from pid file
> /var/run/mysqld/mysqld.pid 070328 19:39:12
ceed. TIA
B.R.
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9712041
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> Pls advise how to locate mysql=E2=80=99s hostname.pid file?
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
'mysq
Hi folks,
CentOS 4.4 amd64
I have been stuck on creating root password;
# mysqladmin -u root password yourrootsqlpassword[code]
Access denied for user ‘root’@'localhost’ (using password: NO)
[/code]
# su -
did not help.
Pls advise how to locate mysql’s hostname.pid file?
Then to run;
#
On 3/13/07, Merlin <[EMAIL PROTECTED]> wrote:
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root
Hi there,
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root -p password testpw
Enter password
On 2/26/06, Arnel Pastrana <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I was installing drupal on my webserver with mysql after i followed
> instructions on how to configure and setup drupal i cant't access the
> root password of my mysql. my password won't work
Hi everyone,
I was installing drupal on my webserver with mysql after i followed
instructions on how to configure and setup drupal i cant't access the
root password of my mysql. my password won't work all.
Any idea how to change my password of root? or is is passible that my
Then quit mysql:
quit
8. Stop mysql from command line with:
/etc/init.d/mysql stop
9. Restart mysql from command line with:
/etc/init.d/mysql start */
<=
Best regards and have a nice week-end,
Cristi
Dustin Krysak wrote:
IS there a way to reset a lost mysql root password?
Dustin Krysak <[EMAIL PROTECTED]> wrote on 11/25/2005
05:28:12 PM:
> IS there a way to reset a lost mysql root password?
>
>
You obvously didn't research the issue very well. Next time search the
archives and the manual (it also has a search function):
http://dev.mysql.c
IS there a way to reset a lost mysql root password?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
> I have also tried mysqld_safe --skip-grant-tables --user=root &
Don't run mysqld under root (even more - fresh versions should
automatically skip this option). What exactly have you done to
restore root password? Please provide exact SQL statements.
What user is &#
Jerry Swanson schrieb:
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
You could start your mysqld with "--*without-grant-tables"* option. But
keep in mind that this will
stop the complete permission
- Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 November 2005 12:19 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Reset root password to mysql?
Hot to
Wednesday, 23 November 2005 12:11 PM
> To: mysql@lists.mysql.com
> Subject: Reset root password to mysql?
>
> How to reset mysql password to mysql?
>
>
> mysql -u root
> ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
> password: NO)
>
-Original Message-
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 November 2005 12:11 PM
To: mysql@lists.mysql.com
Subject: Reset root password to mysql?
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROT
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
I tried to go into mysql with root and the password I had set, and access was
refused.
I finally gave up and decided to reset the root password using the techniques
described on
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
This is a linux machine running mysql Your MySQL
problem I am having with setting up MySQL.
>
> I noticed that my root password isn't set. When i try to set it via
> phpMyAdmin, MySQL doesn't recognize my databases, and denies all
> connections. Now I've tried setting the password via SSH by accessing
> the MyS
Zan B. wrote:
Hello all!
I wanted to discuss a problem I am having with setting up MySQL.
I noticed that my root password isn't set. When i try to set it via
phpMyAdmin, MySQL doesn't recognize my databases, and denies all
connections. Now I've tried setting the password via S
Hello all!
I wanted to discuss a problem I am having with setting up MySQL.
I noticed that my root password isn't set. When i try to set it via
phpMyAdmin, MySQL doesn't recognize my databases, and denies all
connections. Now I've tried setting the password via SSH by acces
restore your root password using such statement:
set password for user 'root'@'your_host'=password('great password');
Than restart server as usual (without --skip-grant-tables).
>I am trying to change my root password for mysql 4.1.7 running on Linux (as
>I f
Hi,
I am trying to change my root password for mysql 4.1.7 running on Linux (as
I forgot it) using the docs found at:
HYPERLINK
"http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html"http://dev.mys
ql.com/doc/mysql/en/Resetting_permissions.html
When I get to the step:
shell&g
Thanks Brent, your solution is the one that worked for me. In 4.0.20
there was no 'Super_priv' column however. ?
On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley <[EMAIL PROTECTED]> wrote:
> There probably is a "root" user, but it's not called root. You can name
> the "root" user whatever you
There probably is a "root" user, but it's not called root. You can name
the "root" user whatever you want. You probably just don't have a user
named "root", which is why you can change the password for user "root".
You want to start MySQL with the skip grant tables options, just like
in the doc
Hi list,
First question - I have a machine that was being managed by Plesk, and
an update to mod_python left Plesk in a nonrunning state (actually
causes apache to segfault). So I am attempting to manually manage
MySQL (the way it should be done!) - but there is apparently no root
user in MySQL's
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> security problem? Is there any way to trick the mysql-server, so that a
> remote-client can claim to be a localhost-client and thus can connect as
> mysql-user root?
No.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensi
On Wed, 15 Sep 2004 17:48:50 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I don't want to allow either. That's why I'm asking. From outside, noone
> can connect as root directly. And as noone has access to localhost
> through ssh or whatever, noone except me can login as root. My question
> w
Hi,
I would never allow anyone except myself to connect to my MySQL server
as the root MySQL user.
I don't want to allow either. That's why I'm asking. From outside, noone
can connect as root directly. And as noone has access to localhost
through ssh or whatever, noone except me can login as root
On Wed, 15 Sep 2004 17:10:27 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> imagine the following setup:
>
> - a mysql-server
> - a client on a different host
>
> Privileges on the mysql-server are setup in a manner, that users can
> connect from every host, but not from localhost (and they d
Hello,
imagine the following setup:
- a mysql-server
- a client on a different host
Privileges on the mysql-server are setup in a manner, that users can
connect from every host, but not from localhost (and they don't even
have access to localhost). root on the other hand is allowed to connect
fr
"DBS" <[EMAIL PROTECTED]> wrote:
> I have a problem, It's been months since I used MySQL and (I believe) I had
> set it up with a root password. Now I can't log on to MySQL as root MySQL
> user and create a new user or manage an existing user (I can log onto ser
IL PROTECTED]
> Subject: Root password lost?; can't manage existing database...
>
>
> Hi,
>
> I have a problem, It's been months since I used MySQL and (I
> believe) I had
> set it up with a root password. Now I can't log on to MySQL as root MySQL
> user a
Hi,
I have a problem, It's been months since I used MySQL and (I believe) I had
set it up with a root password. Now I can't log on to MySQL as root MySQL
user and create a new user or manage an existing user (I can log onto server
as root of course). I'm running MySQL 3.23 and R
Frank Bax wrote:
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is
give root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql -
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=ne
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045: Access den
Jesse <[EMAIL PROTECTED]> wrote:
> anyone know why the mysql daemon fails to start after I set the root
> password according to this:
>
> http://dev.mysql.com/doc/mysql/en/Default_privileges.html
>
> I use the command:
>
> SET PASSWORD FOR 'root'
anyone know why the mysql daemon fails to start after I set the root
password according to this:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
I use the command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'
E8.0 Box. I installd everythign via suse rpms. I ran mysql_install_db when I to run the update root password I get the following error. I'm logged into the server via ssh as root while exicuting the commands. any ideas.
inglewood:/etc # mysqladmin -u root -h inglewood -p password '
This is a new install of mysql 3.23 on a SuSE8.0 Box. I installd everythign via suse
rpms. I ran mysql_install_db when I to run the update root password I get the
following error. I'm logged into the server via ssh as root while exicuting the
commands. any ideas.
inglewood:/etc # mysql
Parminder Singh Chauhan <[EMAIL PROTECTED]> wrote:
> Thanks
> Now I am able to get back the cursor
> but I can't change the password
>[EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysql -u root
>mysql
>Welcome to the MySQL monitor. Commands end with ; or \g.
>Y
I have sorted out the root password.
Can anybody please help me find out why I can't connect to localhost.
since i tried to install and configure mysql.
I can't connect to apache server from other machines. It says
connection was refused when connecting localhost.
Any way of finding t
>
> Chauhan To: MySql <[EMAIL PROTECTED]>
>
> <[EMAIL PROTECTED]cc:
<[EMAIL PROTECTED]cc:
t.com>
wbee to linux) was able to setup mysql4.0.16
> > and I don't know what I have done, I set the root password which I don't
> > know. Now I can't access the mysql.
> > Is there anyway of changing root password.? and how?
>
> Start mysqld with the --skip-gran
> -Original Message-
> From: Parminder Singh Chauhan [mailto:[EMAIL PROTECTED]
>
> After long struggle I (A newbee to linux) was able to setup mysql4.0.16
> and I don't know what I have done, I set the root password which I don't
> know. Now I can't acc
hauhan [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 10:34 AM
-->To: [EMAIL PROTECTED]
-->Subject: Change of root password
-->
-->After long struggle I (A newbee to linux) was able to setup
mysql4.0.16
-->and I don't know what I have done, I set the root password
After long struggle I (A newbee to linux) was able to setup mysql4.0.16
and I don't know what I have done, I set the root password which I don't
know. Now I can't access the mysql.
Is there anyway of changing root password.? and how?
I tried to delete the content of /usr/local/mysq
#x27;t use MySQL too much
these days, but I'll be glad to tell you what I know.
Regards,
Adam
-Original Message-
From: Robert Lund [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:00 PM
To: [EMAIL PROTECTED]
Subject: Re: OS X - can't set root password
Fortuno, Ada
Fortuno, Adam wrote:
If I follow you're email correctly, it looks like you attempting to assign a
password to the root user twice. The first statement you provide:
bin/mysqladmin -u root password **
Sets the password to whatever value you've set in-place of **. T
Robert,
If I follow you're email correctly, it looks like you attempting to assign a
password to the root user twice. The first statement you provide:
> bin/mysqladmin -u root password **
Sets the password to whatever value you've set in-place of **. Then in
the statem
I just installed 4.0.15 on an iBook running Mac OS X 10.2.6. I started
the daemon using bin/mysqld_safe, and then tried to initialize the root
password as instructed. The first,
bin/mysqladmin -u root password **
ran apparently successfully. When I tried to execute the second:
/usr/local
e Korosec [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 9:30 PM
To: [EMAIL PROTECTED]
Subject: Setting root password on OS X
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
/usr/local/mysql/bin/mysqladmin -u root password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
The first wor
Rob Yale wrote:
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Th
Edwin,
check this link. Hope it will help you.
http://www.mysql.com/doc/en/Resetting_permissions.html
Best regards,
Mikhail.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 7:22 PM
Subject: How to recovery the r
Dear List.
This morning we made some changes in the user field of the mysql database,
we changes the root password there, after that we can not get access to
our mysql server with the new root password and with the old password
neither.
How can we do? Is there any procedures for recovery the
er to set a
password for the MySQL root user!*
This is done with the following two commands:
/usr/local/mysql/bin/mysqladmin -u root password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
"
The first command, /usr/local/mysql/bin/mysqladmin -u root password
, wo
> 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
L 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
--
Pau
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
t 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, Wiscon
qlshow mysql' &
'mysqladmin version status proc'. All seems to be fine.
I have deleted the anonymous user with the following commands :
C:mysql\bin\mysql
use mysql
delete from user where User='';
quit
C:mysql\bin\mysqladmin reload
The problem is when I set the root pass
Try setting the user as [EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "John Utting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003 07:57
Subject: Setting root password
Hi,
' &
'mysqladmin version status proc'. All seems to be fine.
I have deleted the anonymous user with the following commands :
C:mysql\bin\mysql
use mysql
delete from user where User='';
quit
C:mysql\bin\mysqladmin reload
The problem is when I set the root password usin
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!!.
1 - 100 of 244 matches
Mail list logo
