Programming Help, OS System Help, Articles, Videos, Books-Web Dot Dev
Welcome, Guest
Please Login or Register.    Lost Password?
Programming Help, OS System Help, Articles, Videos, Books-Web Dot Dev General Discussion Database
Slackware mysql remote .. need help! (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Slackware mysql remote .. need help!
#142
JOHN (User)
Junior Boarder
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
Slackware mysql remote .. need help! 1 Year, 11 Months ago Karma: 2  
i have an OS Slackware 10.2, my question is how to remote mysql for special ip?
I tried :
GRANT All ON *.* TO ''@'IP' IDENTIFIED BY '';
flush privileges;

but nothing, i can;t login for mysql GUI:
ip: xxx
name:root
pass:

what to do??<br><br>Post edited by: adrian, at: 2006/12/15 21:46
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#143
adrian (Admin)
Admin
Posts: 23
graphgraph
User Online Now Click here to see the profile of this user
Re:Slackware mysql remote .. need help! 1 Year, 11 Months ago Karma: 1  
if you are connecting like a root you don;t need for privileges, you already have it.
try ..

update mysql.user set host=&quot;%&quot; where user=&quot;root&quot;;
flush privileges;
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#144
JOHN (User)
Junior Boarder
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
Re:Slackware mysql remote .. need help! 1 Year, 11 Months ago Karma: 2  
UFFFFFFFFFFF Finaly I found the problem:
vim /etc/rc.d/rc.mysqld

the option skip networking was activated!!!
thank you !!!!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
Dorona Brown 1.0.1 by Best of Joomla