Solved

Command in FreeBSD to allow client host to use root in MySQL 5 server?

Posted on 2007-04-06
6
982 Views
Last Modified: 2013-11-22
Hello,

Im new to using MySQL in freeBSD, im fairly experienced getting MySQL to work in a windows environment, but I am trying to learn FreeBSD.  I got as far as installing and running MySQL 5 server on FreeBSD 6.2 successfully. The problem is i dont know how to work my way through managing MySQL in FreeBSD. Normaly I use a client machine with windows and use MySQL GUI tools like MySQL Administrator. But i can becuase i get denied becuase my client machine (192.168.2.6) isnt allowed to.

So with that said, how do i add host 192.168.2.6 to get full access using root, using FreeBSD's localhost?

Thanks to all who help.
0
Comment
Question by:FatherOwnage
  • 2
6 Comments
 
LVL 30

Accepted Solution

by:
todd_farmer earned 250 total points
ID: 18869560
Connect to the server from the FreeBSD host using the command-line interface (as root) and issue:

UPDATE mysql.user SET host = '%' WHERE user = 'root';
FLUSH PRIVILEGES;
0
 

Author Comment

by:FatherOwnage
ID: 18869622
thats the first part i dont know how to do, using the host (FreeBSD) to get into my sql to run that command.

Im logged in as root, and when i run that line it gives me this in return:

# UPDATE mysql.user SET host = '%' WHERE user = 'root' ; FLUSH PRIVILEGES ;
UPDATE: Command not found.
FLUSH: Command not found.


Thanks for the help so far!
0
 
LVL 15

Expert Comment

by:mr_egyptian
ID: 18873179
Here is the relevant section of the documentation:

http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

Please also note the link at the beginning, entitled “Unix Post-Installation Procedures”:

http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
0
 
LVL 15

Assisted Solution

by:mr_egyptian
mr_egyptian earned 250 total points
ID: 18873188
You're just at a shell (bash?).  You need to use the mysql client to connect to the db server:

# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is ....


If you've already set a password, you'll need:

# mysql -u root -p
Enter password:
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now