Hello.
mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
...
shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
--skip-grand-tables
[1] 28712
shell Starting
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it didnt old
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it
Deniss Hennesy wrote:
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
YOu may be need to execute command mysqladmin -u root password
Hi,When i run mysql,mysqlshow,mysqladmin etc from
mysql command,I receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
I have RH9.
Please guide me.
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen
According to the error message, [EMAIL PROTECTED] has a password, but you
aren't supplying it. Add -p to your commands to be prompted for the password.
If you don't know the password, see How to Reset The Root Password
http://www.mysql.com/doc/en/Resetting_permissions.html in the manual.
I didn't found hostname.pid file.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
The next step is to shutdown mysqld, delete the
mysql and temp tables from
your /data/ folder, and then re-run the
scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically
hi,i was attemping,But my problem didn't solved.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created.
To
Hi.
When i run mysql,mysqlshow,mysqladmin or .,I
receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
Please guide me..
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect.
I am constantly getting this:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
when I issue mysql -u root
I can log in if I use mysql -h 192.168.1.10 -u root mysql
I guess I have some
Hi!
You seems to have just installed mysql. The root user should be able to
acces a mysql server from anywhere by default. I don't know why you can
connect from localhost, probably you delete the [EMAIL PROTECTED]? Anyway
it is a good thing to delete the root user after the initial setup, once
now allowing clients to login but I'm not sure what would cuse it not to
allow root to change the password, I dubble and triple checked my entry
but still nothing happens. Once I login to root I do the following
mysql use mysql
mysql UPDATE user SET Password= ('x')
- WHERE
I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I was getting the following error when loging into mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
After searching for an answer I found the answer was to
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am denied
access.
Regards,
Adam
-Original Message-
From: Jerry M.
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr
documentation, there are a LOT a of info about
privilege system in MySQL:
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
TM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
TM From: Victoria Reznichenko
]
- Original Message -
From: Tom McDonough [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 5:40 PM
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
I am having the same problem and cannot find any document which can get
me beyond Access denied
denied for user: 'root@localhost'
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From
password:**
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
If you didn't set password, you don't have to use '-p' option for
connection.
If you want to set password, please, chaeck the following link:
http://www.mysql.com/doc/P/a/Passwords.html
[root@omsrh
: 'root@localhost' (Using password: YES)
[root@omsrh etc]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
I was able access Mysql not being root, but couldn't get access to 'mysql'
database to change user options and all.
When accessing mysql as a user, I
24 matches
Mail list logo