RE: Change of root password
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 the problem Parminder On Tue, 2003-10-28 at 18:51, Barry Byrne wrote: -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 access the mysql. Is there anyway of changing root password.? and how? Start mysqld with the --skip-grant-tables option. Change the password and then run 'mysqladmin flush-privileges' to make the change take effect. www.balpreet.com/ - Barry
Re: Change of root password
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.
Your MySQL connection id is 3 to server version: 4.0.16-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR [EMAIL PROTECTED]('353715');
ERROR 1132: You must have privileges to update tables in the
mysql database to be able to change passwords for others
mysql
You should use UPDATE command and then FLUSH PRIVILEGES or you can also execute FLUSH
PRIVILEGES and then use GRANT statement.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Change of root password
I can't get through I am doing as follow. Is it right or I am doing something wrong? [EMAIL PROTECTED] parminder]# /usr/local/mysql/share/mysql/mysql.server stop Killing mysqld with pid 31796 Wait for mysqld to exit\c done I can't use mysqld [EMAIL PROTECTED] parminder]# /usr/local/mysql/libexec/mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 031029 18:10:34 Aborting 031029 18:10:34 /usr/local/mysql/libexec/mysqld: Shutdown Complete But when i use mysqld_safe session never finishes. Any way mysql server is started. I have to close the console and start it again. [EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables Starting mysqld daemon with databases from /usr/local/mysql/var I can't find what is going wrong On Tue, 2003-10-28 at 18:51, Barry Byrne wrote: -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 access the mysql. Is there anyway of changing root password.? and how? Start mysqld with the --skip-grant-tables option. Change the password and then run 'mysqladmin flush-privileges' to make the change take effect. - Barry -- Parminder Singh Chauhan
RE: Change of root password
to help the mysqld_safe 'finish' you'll need to append an '' to your command, which will have the process start in the background and give you your prompt back. /usr/local/mysql/bin/mysqld_safe --skip-grant-tables now you can hit the enter key, and you'll get your prompt back and the server will still be running. although i'd heed the warnings about runnign your server as root. hth Jeff Parminder Singh Chauhan To: MySql [EMAIL PROTECTED] [EMAIL PROTECTED]cc: t.com Subject: RE: Change of root password 10/29/2003 01:30 PM I can't get through I am doing as follow. Is it right or I am doing something wrong? [EMAIL PROTECTED] parminder]# /usr/local/mysql/share/mysql/mysql.server stop Killing mysqld with pid 31796 Wait for mysqld to exit\c done I can't use mysqld [EMAIL PROTECTED] parminder]# /usr/local/mysql/libexec/mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 031029 18:10:34 Aborting 031029 18:10:34 /usr/local/mysql/libexec/mysqld: Shutdown Complete But when i use mysqld_safe session never finishes. Any way mysql server is started. I have to close the console and start it again. [EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables Starting mysqld daemon with databases from /usr/local/mysql/var I can't find what is going wrong On Tue, 2003-10-28 at 18:51, Barry Byrne wrote: -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 access the mysql. Is there anyway of changing root password.? and how? Start mysqld with the --skip-grant-tables option. Change the password and then run 'mysqladmin flush-privileges' to make the change take effect. - Barry -- Parminder Singh Chauhan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Change of root password
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.
Your MySQL connection id is 3 to server version: 4.0.16-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR [EMAIL PROTECTED]('353715');
ERROR 1132: You must have privileges to update tables in the
mysql database to be able to change passwords for others
mysql
On Wed, 2003-10-29 at 18:49, [EMAIL PROTECTED] wrote:
to help the mysqld_safe 'finish' you'll need to append an '' to your
command, which will have the process start in the background and give you
your prompt back.
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables
now you can hit the enter key, and you'll get your prompt back and
the server will still be running.
although i'd heed the warnings about runnign your server as root.
hth
Jeff
Parminder Singh
Chauhan To: MySql [EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
t.com Subject: RE: Change of root password
10/29/2003 01:30
PM
I can't get through
I am doing as follow. Is it right or I am doing something wrong?
[EMAIL PROTECTED]
parminder]#
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Change of root password
As ROOT on linux goto /etc Edit my.cnf Enter skip-grant-tables Restart the mysql server Change the password. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Parminder Singh Chauhan [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 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/mysql/var/mysql and run --mysql_install_db again thinking it will remove the password but no --effect. --Parminder Singh Chauhan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Change of root password
-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 access the mysql. Is there anyway of changing root password.? and how? Start mysqld with the --skip-grant-tables option. Change the password and then run 'mysqladmin flush-privileges' to make the change take effect. - Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
