Mysql 1104

[Lsy123]

Website URL

(Not applicable, as this is a database connection issue rather than a website access problem)

Error Message

SQL query:

USE user

MySQL said: Documentation

#1044 - Access denied for user ‘if0_38832789’@‘192.168.0.%’ to database ‘user’

Other Information

I am trying to connect to a MySQL database using the phpMyAdmin interface. The credentials allow me to log in, but I cannot select or interact with the ‘user’ database.

[Meishin]

By no means is the database called just “user”.

Common MySQL Connection Errors

Many websites use MySQL databases to store information and settings. However, there are some reasons why the connection to the database may fail. This article describes some commonly seen error messages when connecting to a database, as well as some general tips to keep in mind when setting up a database connection. Common Error Messages Using MySQL is great, but the error message returned if there is an issue logging in to your database can be quite confusing. Here are some commonly seen error…

[Admin]

That’s because there is no user database, which means you cannot access it.

Please note that any database you create through our panel is prefixed with your account username. So if you create a database with the name user, the actual database name will be if0_38832789_user.

You can view the list of databases of your account in the client area and control panel, including their actual names.

Note that we also have a phpMyAdmin installation you can use. I’m not sure if it’s possible to setup and use phpMyAdmin on your own account, I think it needs more access to the database server than we provide with our hosting. If you’re looking to have a database management interface in your own website, you may want to give Adminer a try, it works well and setup is extremely simple (it’s a single PHP file).