problem with MySql user with underscore (Bug ?)

pppplus

Verified User
Joined
Dec 19, 2008
Messages
523
I have a problem to transfer accounts from one server to another.

When a Mysql User has undescore in is name (like user1_mysql_us1), they are not restored in the new server.

I know underscore are not allowed in current version, but I have some mysql users created with softaculous or previous directadmin version.

There is no problem with databases with underscore, they are restored without problem.

So I suppose it's a bug.
Thanks for your help, and correction if possible.
 
Thanks for your reply.
I do not see this feature.

And I did not understand, if I can do something as to update then restore those mysql users.

Ok to stop creating such username ... but I want to continue to use old username. I detect more than 40 user account with _.

I can't change every username before moving accounts.
 
You might want to restore MySQL DBs manually, and restore other data with directadmin. Perhaps there might be another solution.
 
Yes, I think to do this, or maybe just restore manually mysql users.

But I think it is a problem.
I also see that when I restore on the same server, user with _ disappear...

I will probably ask my customer to change their user with _ ... Not good to do now, but maybe better for a long time...

Thanks for your help and replies.
 
Back
Top