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 "root@localhost"? Anyway
it is a good thing to delete the root user after the initial setup, once
you have a full rights user created that can manage the db. To do this,
loginto mysql as root, and create a full-blown user with everything
enable and give it a secure password. like this:
mysql -u root -h 192.168.1.10
Now create a full rights user like this
grant all privileges on *.* to yournewusername_here@"%" identified by
'passowrdhere' with grant option;
flush privileges;
This will create a new user with a set of rights comparable with the
root's own permissions.
Now, with this "superuser" created you can delete the root user
use mysql
delete from user where User='root';
flush privileges;
Now logout, and login again using the new password and the new user!
voilà!
Best Regards!
On Fri, 2004-03-12 at 09:25, Leslie Vance wrote:
> Hello,
>
> I am having a hard time getting Mysql to let root@localhost connect.
>
> I am constantly getting this:
>
> ERROR 1045: Access denied for user: 'root@localhost' (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 sort of host thing mixed up but I have tried all sorts
> of things out of the list with no avail. I using Redhat 9 and I used the
> rpm's distributed by mysql.
>
> Thanks in advance.
>
> Les
--
|...........................................................|
|____ _____ ____ _ |Victor Medina M |
|\ \ \| ____| _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |linux@stripped |
|/_/_/|_____|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 |
| |geek by nature - linux by choice |
|...........................................................|
