how do i cut off any privileges of remoting&accesing my database by my ex programmer

[starstudio]

how do i cut off any privileges of remoting&accesing my database by my ex programmer

Hello guys, i would like to ask you how do i change any remote acces of my ex programmer, or any kind of connection to my data bases unauthorized by me the owner ? and tell me how do i change databases passwords
Please help me with that. Thank you in advance

 

[floyd]

Databases do not have passwords. Users have passwords. You have to change the password of any and all users of that database.

Go to mysql management, click the database, click modify password the database user

 

[starstudio]

thank you floyd

Databases do not have passwords. Users have passwords. You have to change the password of any and all users of that database.

Go to mysql management, click the database, click modify password the database user

thank you for this important reply to my need, if i am not bothering, may i ask you to explain the exact steps of doing what you have answered, i would like to know step by step, but the second questions is if i change that the databases will be able to comunicate with the script and site or i have to change all the passwords and to be one and the same

thank you in advance

 

[scsi]

Unless you have allowed remote access to your databases they shouldnt even be accessable outside of your server. But you would have to check under the Mysql management section to see if that is enabled or not. Then you would have have to change any usernames or passwords.

 

[starstudio]

how do i veify if it is remoted

Unless you have allowed remote access to your databases they shouldnt even be accessable outside of your server. But you would have to check under the Mysql management section to see if that is enabled or not. Then you would have have to change any usernames or passwords.

how do i check if he remote access to my databases? i am in need here please help me with appropriate information.

thank you all in advance

 

[nobaloney]

Unless anyone else needs remote access you can simply disable it:

Check to make sure you have an /etc/my.cnf file.

Add the line

skip-networking

directly under the line:

[mysqld]

If you don't have an /etc/my.cnf file then create this minimum file:

[mysqld]
skip-networking

Then save the file and restart the mysqld daemon.

Jeff