Home » MySQL
Now, you want to connect to this DB as root from another machine and have full access. Here’s what you do:
This will make this database fully accessible to a “root” user connecting from ANY system, as long as the correct password is specified.
The correct MySQL GRANT syntax
on September 21, 2006 – 12:18 pm 5 Comments
It is surprising how many people run into problems trying to use the GRANT command: everything from not being able to access a database table to losing admin access to MySQL altogether. There’s a bunch of Web sites giving incorrect examples of using this command. Among these sites is, surprisingly, mysql.org. So, to save humanity, here’s my take on the GRANT issue and pay attention to the use of single and double quotes.
Example 1
Let’s say you want to create a new database called “my_drug_deals”, so you do this:
mysql -uroot -ppassword mysql> CREATE DATABASE my_drug_deals ; mysql> quit
Now, you want to connect to this DB as root from another machine and have full access. Here’s what you do:
mysql -uroot -ppassword mysql> GRANT ALL PRIVILEGES ON my_drug_deals.* to root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION ; mysql> quit
This will make this database fully accessible to a “root” user connecting from ANY system, as long as the correct password is specified.
5 Comments »
1 Pingbacks »
-
[…] MySQL to grant your database user account necessary permissions to access the new […]
![wyryr1sn52gntzn65v4fpz5lc6v[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/wyryr1sn52gntzn65v4fpz5lc6v1-80x80.jpg "Plundering Facebook Photo Albums")
![clfud46mxf2t5zph2l04zlpgl1d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/clfud46mxf2t5zph2l04zlpgl1d1-80x80.jpg "Scraping a Web Page in Bash")
![DSCF5361[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/DSCF53611-80x80.jpg "Processing Videos with ffmpeg and Lightroom")
![Cat-Devouring-A-Bird-Pablo-Picasso[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/Cat-Devouring-A-Bird-Pablo-Picasso1-80x80.jpg "Searching Twitter")
![91ebozy1e3b138waujy28agrngy[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/91ebozy1e3b138waujy28agrngy1-80x80.jpg "Generating Random Text Files for Testing")
![iwoau71okwxqh4jv3k4ook32qps[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/iwoau71okwxqh4jv3k4ook32qps1-80x80.jpg "Finding Cron Jobs")
![5gtysva4wkc8mzc1k3e66vaycxx[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/5gtysva4wkc8mzc1k3e66vaycxx1-80x80.jpg "Understanding Memory Utilization in Linux")
![sy2zeb1vp2h8itlxfbbylw0jrm0[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2019/12/sy2zeb1vp2h8itlxfbbylw0jrm01-80x80.jpg "Validating HTTPS Cache Peers for Squid")
![Photo-2019-10-07-14-39-03_0266[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/Photo-2019-10-07-14-39-03_02661-80x80.jpg "Verifying SNMP Connectivity on Multiple Hosts")
I forgot to file a grant W2, or whatever its called, and I already recieved my tax return. The grant is for $3000. It was paid directly to my school. Does this qualify as income? Will it affect my Earned Income Credit?
I relieved a call telling me the government approved me for a grant and they need $ 200 and some odd money for processing at weastern union . Is this a scam ?
What I mean is can they create agreements that their works cannot be resold, for example an oil paintings artist. Could he create an agreement restricting resale until after his death to allow him to control pricing while he is alive?
I want to know how to get a government grant to do loan modifications for free. I have heard of such programs but i cannnot really get information on it cause search engines are so cluttered with other stuff.
Better way is using any gui tools like dbforge studio for mysql rather than using mysql console to manage users and privileges.