MySQL problems

[fusionhost]

Hey,

I'm having a problem with the databases being renamed, example:

Orginal database name:
1234

After import:
admin_1234

How can I get rid of the "admin_ " bit so it goes back to its orginal filename as none of my sites will work till the "admin_" bit has gone.

Regards,
Jon

 

[nobaloney]

Basic answer: don't use DirectAdmin, as DirectAdmin requires that databases include the username (in this case admin) to keep track of which user owns which database.

If you're going to be the only user on the server you can rename all the files in the database to whatever you want, but make sure you never try to use DirectAdmin to manage the databases. And remember that DirectAdmin won't keep track of the databases for you, or even help you back them up. You'll need to use an external program (phpmyadmin?) for all your management. I do not recommend this unless you're familar enough with MySQL and know what you're doing.

Most hosts have this kind of limitation or similar, and most commercial software is written so that the database name is in a variable and loaded from a configuration file.

Jeff

 

[fusionhost]

When I try to remame a database in phpmyadmin I get this error:

#1044 - Access denied for user 'admin'@'localhost' to database 'tlforum'

Also how do I reset the administrator email password? As I cannot login to my email (for the main domain)

 

[nobaloney]

It appears you don't have the proper admin password.

You should log into DirectAdmin (if you can) and change the admin password.

If you can't log into DirectAdmin then you should try a shell login as root, and change the admin password.

Jeff

 

[fusionhost]

I'm logged in with the password (Direct Admin and MySQL) that I set, but for some reason not my email nor do the changes in MySQL

Update

Managed to get into my emails, it is just the MySQL problem renaming now

 

[fusionhost]

Nobody have a idea?