mysql prob...

[MrBuSta]

Hello guys,

I have prob with MySQL connecting on my vps (linux)
My server runing since 2 month and this is first day when i got error on navicat Too many Connections!   Website down,Forum tell sql connection problem,Invaild password in game and i need allways restart mysql with this command /etc/init.d/mysqld restart and after restart server to for work again. I dont know why make this my mysql...Its possible how someone attack my MySQL port and this is make down it?

[MrBuSta]

+ How i can change my mysql 3306 port to other? 

in /etc/my.cnf not have any port number thing on my vps for change it...

[WorldOfWars]

you cant change the mysql port , or change all configurations but i dont know if is possible

[MrBuSta]

you cant change the mysql port , or change all configurations but i dont know if is possible

Ok thanks...

[LikeToMove]

Hello Mr, if you have problems with a (possibly) MySQL attack you can bind your mysql server to 127.0.0.1

I know, in this way you cannot be able to connect via navicat, but just use a bit of brain, you can simply use a web tool like phpmyadmin and secure the access using .htaccess

my.cnf

bind-address = 127.0.0.1

[MrBuSta]

 

Hello Mr, if you have problems with a (possibly) MySQL attack you can bind your mysql server to 127.0.0.1

I know, in this way you cannot be able to connect via navicat, but just use a bit of brain, you can simply use a web tool like phpmyadmin and secure the access using .htaccess

my.cnf

bind-address = 127.0.0.1

Hello,LikeToMove,Thanks for help ill try it soon as its possible and tell tomorrow worked or not

It would be good if you can tell me install for phpmyadmin too please

[LikeToMove]

This is a *little* guide for phpMyAdmin on centos systems.

You need just to skip the second step (MySQL Installation)

 

2

[MrBuSta]

This is a *little* guide for phpMyAdmin on centos systems.

You need just to skip the second step (MySQL Installation)

 

2

Thanks.Im installed it alredy now

I hope now no more attack for mysql server

 

 

[MrBuSta]

@2

Can tell me how to make .htaccess for it? please

[MrBuSta]

Solved.Close please