Mysql grant all privileges to a user on everywhere

Question

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?

Nadeem_MK · Accepted Answer · 2014-03-19T09:46:47.983

13

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';

edited Mar 19 '14 at 09:46

answered Mar 19 '14 at 09:31

Nadeem_MK

7,533
7
50
61

How can I add password into the sql query – Erdinç Özdemir Mar 19 '14 at 09:35
It should be done on creation of the user; `CREATE USER 'user_name'@'%' IDENTIFIED BY 'password';` – Nadeem_MK Mar 19 '14 at 09:42
or use `grant all privileges on mydb.* to user_name@'%'identified by 'password';` will update answer accordingly – Nadeem_MK Mar 19 '14 at 09:44
1

Does the grant command create the user? If not then how does defining the password work there? – Marcos Pereira Apr 18 '19 at 16:39

score 0 · Answer 2 · answered Jul 19 '22 at 15:16

0

GRANT ALL PRIVILEGES ON *.* TO 'root'@'Hello@123' WITH GRANT OPTION;

answered Jul 19 '22 at 15:16

Rakesh Vishwakarma

35
4

I think you may be swirling up the query up the loo, mainly the password with the host. As in `'root'@'Hello@123'` should be `'root'@'localhost'` and to set the password, `IDENTIFIED BY 'Hello@123';` Or do you have an explanation to clear this up? [Docs](https://dev.mysql.com/doc/refman/8.0/en/grant.html). – treckstar Jul 24 '22 at 04:13

Mysql grant all privileges to a user on everywhere

2 Answers2