How to turn MySQL Online?

[InTheEndॐ]

I can't connect through my computer in my dedi's mysql. i don't care about this but i have some scripts in my website and they dont work cause MySQL is offline.

When i try to connect ex. with another user i have this error http://prntscr.com/1nq76p a solution was to re-install mysql but i can't do this right now so anyone can tell me what to do?

[™® Stergios ®™]

I can't connect through my computer in my dedi's mysql. i don't care about this but i have some scripts in my website and they dont work cause MySQL is offline.

When i try to connect ex. with another user i have this error http://prntscr.com/1nq76p a solution was to re-install mysql but i can't do this right now so anyone can tell me what to do?

You need to enable remote access from the server side..You are using windows or linux for the server?

[InTheEndॐ]

You need to enable remote access from the server side..You are using windows or linux for the server?

Windows

[™® Stergios ®™]

1) Find your mysql path , Example "C:\Program Files\mysql\bin".

2) Open a cmd (command prompt)

 

--------------We will go to mysql path with cd and login to mysql

 

3) cd C:\Program Files\mysql\bin

4) mysql -u root -p mysql      (It will ask you for your mysql password, right it and click ok)

 

--------------We are logged in now. ('root' is the username , 'yourpass' is your password for the remote connection, '%' is the basic part that allows all kind of remote connections. If for example you will set 192.168.1.150 , only machine with that ip it will be able to login with that user and pass)

 

5)GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'yourpass';

6)exit

 

7)It might need to restart your mysql, but at windows i think you can skip this step.

--------------You are done , if you have problem again following the upper steps it will need some configuration at .ini of the mysql , let me now and i will show you how to change it.

 

I hope that helped you . If you have any question feel free to reply.

[InTheEndॐ]

Tenk you mr.nice guy :D

[™® Stergios ®™]

Tenk you mr.nice guy :D

My pleasure :) , Lock this topic.

[^Wyatt]

My pleasure :) , Lock this topic.

Locked then.