Mysql grant all privileges to a user on everywhere

mysql privileges grant
Erdinç Özdemir picture Erdinç Özdemir · Mar 19, 2014 · Viewed 12k times · Source

In my windows forms application I use Mysql to get data. (I use MySql.Data.dll)

Here is my connection string:

server=xxx.xxx.xxx.xxx;user id=user_name;Password=userpass;database=products

When I want use my application on a computer, I must add computer's ip to remote mysql connection on cpanel. I want grant all privileges (on every IP) to user which I use on my connection string.

How can I do it?

Answer

Nadeem_MK picture Nadeem_MK · Mar 19, 2014

Try giving the user a "Super User" privileges;

GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' WITH GRANT OPTION;

to add password into the query;

GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' identified by 'userpass';

Related questions

Why is a "GRANT USAGE" created the first time I grant a user privileges?

I'm new to the admin side of DBMS and was setting up a new database tonight (using MySQL) when I noticed this. After granting a user a privilege for the first time, another grant is created that looks like GRANT …

Read More
Remove privileges from MySQL database

Before you think this is a duplicate question, I believe I have a unique, even if it is somewhat dim-witted, case. A few days ago, I upgraded the version of MySQL on my Ubuntu 10.04 server to 5.3.3 (it's ahead of the …

Read More
"IDENTIFIED BY 'password'" in MySQL

I often see in many MySQL tutorials that people use command IDENTIFIED BY 'password' both during user creation and granting him privileges. For example: CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost' IDENTIFIED …

Read More