Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hello. > mysqladmin:connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2)' ... > shell>safe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid > --skip-grand-tables & > [1] 28712 > shell> Sta

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 (yourpass

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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" in the manual. M

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 basi

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 r

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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. > >

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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:http://lists.mysql

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 y

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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]

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

> 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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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.

RE: ERROR 1045: Access denied for user: 'root@localhost'

PROTECTED] 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... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subje

Re: ERROR 1045: Access denied for user: 'root@localhost'

[EMAIL PROTECTED] - 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 ca

Re: Re: ERROR 1045: Access denied for user: 'root@localhost'

'root' user in Linux is a "superuser" of OS, not of MySQL. Look at the MySQL 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.htm

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... 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

Re: ERROR 1045: Access denied for user: 'root@localhost'

Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: >> Hello, i'm having a problem accessing mysql database. I don't recall >> setting a password for root, but when i try to set that password. This is >> happening right after i run mysql_install_db >> >> [root@omsrh etc]# mysql -u root -p