Although I am specifying the correct username, the server responds saying that access is denied for a user at "localhost."
Please advise.
Importing database
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
I've posted my local database to a SQL file, and am trying to import it to my database at HostingRails. I've created the database and associated a user with it in the cPanel. When I try to import the file, I get the same error from both the command line and phpMyadmin. I'm pasting the command-line version below.
Although I am specifying the correct username, the server responds saying that access is denied for a user at "localhost."
Please advise.
Although I am specifying the correct username, the server responds saying that access is denied for a user at "localhost."
Please advise.
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
edit: Please do not post your username or hostname on the forums.
2007-09-17 02:39 PM
- William
- Posts: 1052
- Starts: 32
- Wiki Edits: 56
Hi there-
I would recommend trying to reset your password, and if that doesn't work try shortening the name of your database. cPanel sometimes has trouble with longer db names.
(Also, please note that for security reasons I removed your username and hostname from your post.)
I would recommend trying to reset your password, and if that doesn't work try shortening the name of your database. cPanel sometimes has trouble with longer db names.
(Also, please note that for security reasons I removed your username and hostname from your post.)
2007-09-17 02:42 PM
- Rahul
- Posts: 498
- Starts: 0
- Wiki Edits: 1
Hello,
Can you confirm that you are using the correct password for that mysql user. Please just try to connect to your mysql database using the mysql user and its respective pass and see if it connects properly.
i.e mysql -D <databasename> -u <mysqlusername> -p (this format from your shell)
Can you confirm that you are using the correct password for that mysql user. Please just try to connect to your mysql database using the mysql user and its respective pass and see if it connects properly.
i.e mysql -D <databasename> -u <mysqlusername> -p (this format from your shell)
2007-09-17 02:43 PM
Regards,Rahul
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
I shortened the database name, and now have access from the command line. I continue to get the same error from phpMyAdmin.
2007-09-17 08:24 PM
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
I've just tried to import the database from the command line. Although I can gain access to the mysql command-line prompt with my username and password, I receive the same error as before when I try to import the database.
ERROR 1044 (42000) at line 21: Access denied for user
Please advise - I'd really like to get this application posted as quickly as possible.
ERROR 1044 (42000) at line 21: Access denied for user
Please advise - I'd really like to get this application posted as quickly as possible.
2007-09-17 08:28 PM
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
ERROR 1044 (42000) at line 21: Access denied for user
I've tried several different things, and it keeps giving me an error. I do notice that even though I'm clearly specifying the new database name, the error message is referring to the original database - which has been dropped.
I've tried several different things, and it keeps giving me an error. I do notice that even though I'm clearly specifying the new database name, the error message is referring to the original database - which has been dropped.
2007-09-17 08:46 PM
- Tierthree
- Posts: 5
- Starts: 1
- Wiki Edits: 0
All right - I checked the .sql file created by mysqldump, and found that it's attempting to create the original database name. I changed this, and the import worked.