Skip to main content
Formatting, typos, grammar
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

First Checkcheck whether you given a proper privilegeprivileges to the user on your current host through which you are trying to connect into MySQL server. 1:-Check your hostname first 2:-Then login into the MySQL through super user like 'root' 3:- Check whether the privileges are provided or not select * form mysql.user where host="host_name"\G; 4:- give It all privilege first, then try to connect again

  1. Check your hostname first
  2. Then login into the MySQL through super user like 'root'
  3. Check whether the privileges are provided or not select * from mysql.user where host="host_name"\G;
  4. Give all privileges first, then try to connect again.

grant all on . to 'user'@'host_name' identified by 'Password'; </>

grant all on *.* to 'user'@'host_name' identified by 'Password';

I hope this is helpfull forhelpful to you.

First Check whether you given a proper privilege to the user on your current host through which you are trying to connect in MySQL server. 1:-Check your hostname first 2:-Then login into the MySQL through super user like 'root' 3:- Check whether the privileges are provided or not select * form mysql.user where host="host_name"\G; 4:- give It all privilege first, then try to connect again

grant all on . to 'user'@'host_name' identified by 'Password';

I hope this is helpfull for you.

First check whether you given proper privileges to the user on your current host through which you are trying to connect to MySQL server.

  1. Check your hostname first
  2. Then login into the MySQL through super user like 'root'
  3. Check whether the privileges are provided or not select * from mysql.user where host="host_name"\G;
  4. Give all privileges first, then try to connect again.

</>

grant all on *.* to 'user'@'host_name' identified by 'Password';

I hope this is helpful to you.

Source Link
Rk Singh
  • 145
  • 1
  • 12

First Check whether you given a proper privilege to the user on your current host through which you are trying to connect in MySQL server. 1:-Check your hostname first 2:-Then login into the MySQL through super user like 'root' 3:- Check whether the privileges are provided or not select * form mysql.user where host="host_name"\G; 4:- give It all privilege first, then try to connect again

grant all on . to 'user'@'host_name' identified by 'Password';

I hope this is helpfull for you.