Jump to content

Database connection problem - create database if not exists


answersmode
 Share

Recommended Posts

Please help me........

DATABASE CONNECTION PROBLEM  - CREATE DATABASE IF NOT EXISTS `lwteswm664_ltingesjfo_itbd` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Error

SQL query:

 

--
-- Database: `lwteswm664_ltingesjfo_itbd`
--
CREATE DATABASE IF NOT EXISTS `lwteswm664_ltingesjfo_itbd` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

MySQL said:

#1044 - Access denied for user 'newhost'@'localhost' to database 'lwteswm664_ltingesjfo_itbd' 

 

I'm facing this peoblem in my website xxxxx and xxxxx When I wanted to upload my databaz backup file.

Now what can I do?

Please help me........

 

 

Capture.PNG

Link to comment
Share on other sites

I think theres a Problem with your user rights.

You have a Database "itinffcl_kwbdm" (Screenshot), and your backup create (or trys to create) a database with the name "lwteswm664_ltingesjfo_itbd". Your user have no rights to create a new database.

 

I think you want to import the backup to the "itinffcl_kwbdm" database?

 

If you just want to import the data, you have to delete the CREATE DATABASE command inside of your backup file.
Or you can change the Database name inside of your backup from "lwteswm664_ltingesjfo_itbd" to "itinffcl_kwbdm"...

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...