can only log in as root - what have I missed? 1

[MatthewP]

For some reason I can only log in as root to MySQL on a redhat system. I went in as root and created a database, added users to the user and db databases, but still cannot connect as any other user other than root in telnet, and also cannot connect through Perl scripts. Have I missed something out?...

1. I connected with mysql -p mysql and entered password
2. create database myDataBase;
OK
3. Show databases;
They came up - all is well.
4. Insert into user (host, user, password) values ('%', 'my_username', password('my_password'));
Query QK. 1 row affected (0.02 sec)
5. Insert into db values ('%', 'myDataBase', 'my_username', 'y','y','y','y','y','y','y','y','y','y');
Query OK, 1 row affecred.
6. flush privileges;
Query OK, 0 rows affected

 

[Broccoli2]

If you want to connect from the same machine that is running the MySQL server, you need to explicitly have a '

localhost

' entry in your

Host

columns. The '

%

' does not match '

localhost

'. Repeat (or replace) steps 4 and 5 with

localhost

instead of

%

.

-Rob

 

[MatthewP]

Wow thanks. That's sorted it nicely. I was only putting the % in because I was told to - wrongly obviously. What exactly does the % mean then?

Thanks,
Matt.

 

[Broccoli2]

'

%

' is a wildcard - it stands for anything (with the exception of

localhost

). You can use it to control access depending on where a user is trying to connect from.

-Rob