search

sgtcaze / NametagEdit

Simple plugin to give players custom nametags
GNU General Public License v3.0
194 stars 133 forks source link

Cannot increase max_user_connections of MySQL #437

Open LJIT-WD opened 4 years ago

LJIT-WD commented 4 years ago

Bug Report

Type /ver NametagEdit and post the output. 4.4.6

What version of Bukkit/Spigot/PaperSpigot are you using? Type /ver Paper version git-Paper-112 (MC: 1.15.2)

What plugins are you using? Type /plugins Plugins (11): Citizens, CitizensCMD, HubBasics, LoginSecurity, MessageAnnouncer, NametagEdit, ServerSelectorX, ViaBackwards, ViaRewind, ViaVersion, VotingPlugin

Please explain your issue. How do you trigger it? I use waterfall (fork of bungeecord), so I use MySQL for all my plugins. There are at least 10 active connections. There is no options for me to change the max_user_conections in config.yml.

Are there any errors in the console? Please use: https://pastebin.com https://hastebin.com/limepakifo.md

RazzerDE commented 4 years ago

Try this:

  1. login to your server via ssh

  2. mysql -u root

  3. type: "SET GLOBAL max_user_conections=200000;"

and restart your mysql server

LJIT-WD commented 4 years ago

I only have SFTP and console access. For MySQL server, I only have phpMyAdmin access. How can I do that?

RazzerDE commented 4 years ago
  1. connect to server with sftp
  2. edit the file /etc/my.cnf and search for "max_user_connections"
  3. service mysql restart