+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: mysql prob... (/showthread.php?tid=3387)
Pages:
1
2
- MrBuSta - 01-28-2014
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 - 01-28-2014
+ 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 - 01-28-2014
you cant change the mysql port , or change all configurations but i dont know if is possible
- MrBuSta - 01-28-2014
you cant change the mysql port , or change all configurations but i dont know if is possible
Ok thanks...
- LikeToMove - 01-28-2014
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 - 01-28-2014
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 - 01-28-2014
This is a *little* guide for phpMyAdmin on centos systems.
You need just to skip the second step (MySQL Installation)
2
- MrBuSta - 01-28-2014
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 - 01-28-2014
@2
Can tell me how to make .htaccess for it? please
- MrBuSta - 01-28-2014
Solved.Close please