Create user for DB mysql

J

jdn1976

Verified User
Joined
Mar 30, 2020
Messages
107
Hello, I am trying to create a user to an existent mysql database but when I type name for the user wp660 says the error:

value is too long: Max=3

how do I increase this?

Anotação 2020-05-05 145237.jpg
 
your mysql version compatible with longer names?
you must restart directadmin/mysql after modifications
 
Zhenyapan said:
your mysql version compatible with longer names?
you must restart directadmin/mysql after modifications
Click to expand...

Yes I restarted mySQL.
I have transfer this account from a cPanel server with mySQL 5.6 and I am using also mySQL 5.6 on DA server.
 
with this mysql version long names not allowed, use short names, replace in website configs dbname/dbuser with new.
 
Zhenyapan said:
with this mysql version long names not allowed, use short names, replace in website configs dbname/dbuser with new.
Click to expand...

Odd, now is given the error:
Cannot load from mysql.db. The table is probably corrupted

I already make a search on google but not solve the problem. Any ideas?
I am creating user and db using DA panel.
 
bdacus01 said:
could help


max_username_length=10


Max length a username can be. Max is 30. It is limited to max of 14 with MySQL 5.5/5.6 and MariaDB 5.5 because of the 16 character mysql database name limit and the username naming prefix.
http://www.directadmin.com/features.php?id=189
https://www.directadmin.com/features.php?id=2294
Click to expand...

Thanks, but I already set 20 when I setup the server.
I think this should solve the issue using 20 char for username. but not.
 
You set what to 20?
You have 30 total.
and only 16 total for mysql.

You have 18 in the Screenshot which won't work. You need 2 fewer characters from somewhere.
 
bdacus01 said:
You set what to 20?
You have 30 total.
and only 16 total for mysql.

You have 18 in the Screenshot which won't work. You need 2 fewer characters from somewhere.
Click to expand...

Thanks for your reply. I solve the problem another way.
I deleted the database and user.
I created again the database and user with same password of wordpress configuration and then upload the SQL file.

It was given error on DB on cpanel full backup.
 
You must log in or register to reply here.
Back
Top