I want to grant the user email@example.com read write access to the database named mythconverg on the mysql server on 192.168.1.252 using password mythtv. How do I do this?
I tried on the PC with the mysql server:
msyql> grant all privileges on *.* to firstname.lastname@example.org identified by 'mythtv' with grant on;
This seemed to work last night and I was able to access
the database. However it doesnt work this morning. I get an Error 2003: Cant connect to Mysql server on '192.168.1.252' (111) when I try to do a
user@localhost]mysql -h 192.168.1.252 -u mythtv
If i append a -p at the end of that, it prompts me for a password and then shows me the error. So apparently I am able to access the mysql server but authentication fails.
If i try to access locally on the mysql server, I can access. Any ideas?