Hello all,
I register free host on byethost.com. I go to cpanel.byethost.com and created database on mysql database. The database name is b17_9059257_mydb, so I go to phpmyadmin and import mydb.sql. The MySQL said: #1046 - No database selected. I go to database menu in phpmyadmin and create a database. The mysql message: #1007 - Can't create database 'b17_9059257_mydb'; database exists. I created new database (b17_9059257_mysql1. The mysql message: #1044 - Access denied for user 'b17_9059257'@'%' to database 'b17_9059257_mydb1'. Then I go to sql menu create database by query: "create database aaa;" The mysql message: #1044 - Access denied for user 'b17_9059257'@'%' to database 'aaa'.
I search error on google and other forums. I was tried test, but not ok.
Please help me,
Thanks very much.
By hoangbien on
Comments
Can't do it in PHPMyAdmin
You can't create a database in PHP My Admin. You have to do it from within cPanel: In the Databases section of cPanel, go to "MySQL Databases". There you can create a database. You also have to create a database user and then grant permissions for that user to use that database.
This signature is currently blank
My website run show a none page.
Thanks James,
I can create a database in mysql database. But I can't create a database user and grant permissions for user. because I don't see link or menu allow create database user.
I have just come back cpanel and import database ok. so, I configed setting.php file connect to database ok. but when my website run it show a none page. My website develop by drupal.
Please help me.
Thanks you,
It's the same screen as to create the database
On that same screen you'll find the place to create a database user. See screenshot. Remember the password, as you'll need the username, the password and the database name in the settings.php file
Once you've created a user, a third section of that screen opens up in cPanel to allow you to assign that user to the database you created earlier
This signature is currently blank
Thanks James, I imported
Thanks James,
I imported database successful. So, I config settings.php file with my database username, password, host and database. But when I running my website, the website load as none page and no message. I used byethost17.com free for test my website. Please help me, Thanks you very much.
So you've now created the user
and assigned full control for that user over your database, right?
Check your drupal installation folder to see if there's a file there named error_log. That may shed some light.
Otherwise, I suggest you contact your host for support.
This signature is currently blank
Thanks James,
Thanks James very much,