[Bulk] RE:MySQL Help - Remote Access

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Wed Jun 28 01:34:27 UTC 2006


Charlie Yang wrote:
> I'm not clear what you did, usually i do below steps:
> 1. log into mysql
> 	mysql -u root
>
> 2.	INSERT INTO user (Host,User,Password)    VALUES('%','root',(''));
> 	FLUSH PRIVILEGES;
> 	#comment:  '%' can chanage to ip like "192.168.1.5"
>   
I used grant instead of insert into, and this had am identical effect. 
The table 'user' was updated.

I am still stuck....

Stephen

--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml





More information about the Legacy mailing list