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
- Check your hostname first
- Then login into the MySQL through super user like 'root'
- Check whether the privileges are provided or not
select * from mysql.user where host="host_name"\G;
- 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.