Hi,
Is it saying access denied as blah@my machine or is it not connecting at
all?
If its saying access denied its usually because you've not added a
wildcard host user.
If you log into mysql (as root) you can try the following:
USE mysql;
SELECT Host, User FROM user;
You should see something like:
+-------------+------------------+
| Host | User |
+-------------+------------------+
| localhost | root |
| myhostname | root |
| 127.0.0.1 | root |
| ::1 | root |
| localhost | debian-sys-maint |
| % | rduser |
+-------------+------------------+
Some times you can accidentally get rid of the localhost entries which
would give you the access denied problems. You'll need to add these
entries back (usually % means any host including local so its all weird
if thats the problem).
Theres a page on the mysql site about adding users if you need to readd
anything:
http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
Feel free to reply back on/off list if you need to, I figure theres no
point overloading with info until you know what the problem is.
Regards,
Wayne Merricks
The Voice Asia
On 01/07/14 16:16, Nathan Steele wrote:
Setup my new system for remote access, but now have no local access to
mysql....What did I miss? I have this working on my other system, but
it's been three years since I set it up......
Basically followed instructions here:
http://rivendell.tryphon.org/wiki/Remote_Client_Access
But using webmin istead of mysql-admin.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
