Hello, I can't understand or code in MYSQL language (whatever that is) at all, and I have no experience with it, I just know how to create databases, put the database info into the script and let the script do the rest.

Now I am faced with a scam host who doesn't want to fix my site, so I have got a new host and I can't seem to transfer my SMF forum over. I have transferred all the files from the public_html folder, but now I need to trasnfer my mySQL databases.

I exported the database from old host, logged in to cpanel, went to phpmyadmin, went to import, and uploaded the database, in the order, thats all I did.

I got this error:

Error

SQL query:

--
-- Database: `soldatbo_smf`
--
CREATE DATABASE `soldatbo_smf` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'soldatbo'@'localhost' to database 'soldatbo_smf'

Hello? No one knows???

Looks like the user soldatbo doens't have been granted the right to create databases.
Do you have control over the permissions that are granted to your db user?

Originally Posted by tripy

Looks like the user soldatbo doens't have been granted the right to create databases.
Do you have control over the permissions that are granted to your db user?

Umm... I have a reseller, so probably. I didn't create a db, I thought when I import it, it creates it for you, right?

I thought when I import it, it creates it for you, right?

Yes, that's what the "CREATE DATABASE" command is.

The problem is that the user you are logged into the database with seems to lack the permission to create new databases.

Originally Posted by tripy

Yes, that's what the "CREATE DATABASE" command is.

The problem is that the user you are logged into the database with seems to lack the permission to create new databases.

I can create databases manually, so doesn't that mean I have permission?


Thanks so much for replying XD

You might have permission, but it would need to be the same user. Is the user on the new host soldatbo@localhost?

Why not just create the database manually and remove that line from the script so you just import the tables?

Remove what line from what script? A short, quick, step by step tut would help alot. Thanks.

EDIT: The username and password is the same I think.

Oh, please someone help!

Sorry to bump again, but I really need help. Maybe I will try PMing.

paste the 30 or so first line of your dump here, first.
Then, what kind of hosting plan do you have, and how many db are you allowed to create ?
Did you created a db user in the control panel, or did you just fired the script?

Originally Posted by tripy

paste the 30 or so first line of your dump here, first.
Then, what kind of hosting plan do you have, and how many db are you allowed to create ?
Did you created a db user in the control panel, or did you just fired the script?

I have an unlimited reseller on both my old host and my new host. I just fired the script. If I create the database I get this error:

#1007 - Can't create database 'soldatbo_smf'; database exists

First 30 lines of the exported .sql file is as follows:

-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 28, 2009 at 08:10 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `soldatbo_smf`
--
CREATE DATABASE `soldatbo_smf` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `soldatbo_smf`;

-- --------------------------------------------------------

--
-- Table structure for table `soldatbo_admin_info_files`
--

I have an unlimited reseller on both my old host and my new host.

good.

I just fired the script. If I create the database I get this error:
#1007 - Can't create database 'soldatbo_smf'; database exists

Ok, so I'd say your best bet would be to modify the sql file and modify the line

CREATE DATABASE `soldatbo_smf` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

into

CREATE DATABASE IF NOT EXISTS `soldatbo_smf` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

try it, and tell me again what results you have.

Same thing

Error

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


MySQL said:
#1044 - Access denied for user 'soldatbo'@'localhost' to database 'soldatbo_smf'

With which user do you log into your db system ?
Does it have the admin rights to your db, or is it an unprivileged user ?

Umm. I have a reseller, right? So I login to my reseller account's WHM. Create username soldatbo with password and website (soldatboards.com). Then I change nameservers at my registar, then I go to soldatboards.com/cpanel

Login to cpanel with the account details I made in WHM, go to PHPMYADMIN and go to import.

Bump.

Try going to cpanel and creating the database manually. You'll just have to give it a name. Then create a user for that database, which can be any name you want. cpanel will likely add your username to the front of the database and username and look something like

soldatbo_databasename
soldatbo_username

then set the new user to work with the database you manually created granting it whatever privileges you need.

Then go to phpmyadmin and import your sql. See if that works or at least gets rid of the error about the user not having permissions.

So I login to my reseller account's WHM. Create username soldatbo with password and website (soldatboards.com)

Ok, but which user is logged in the db. And where did you created the db user? From the db or from the panel.

I never used any control panel (never had to), and as Steven suggested, it may be because it uses another user internally.

All that I can say is that if
1) connet to a mysql server with the cli program with "mysql -h serverIp -u user -p"
2)type "create database dbName if not exists;"
3)issue "grant all on dbName.* to xxx@localhost identified by 'mySuperPassword";

and it will be ok.
Now, the only question is, when you are in your db, what is the user you are connected with, and what privileges does he have.

Ok, I made a video just for you guys. This is exactly what I did. Not including exporting the .sql file from the other account, and changing the nameservers.

http://www.soldatboards.com/video/mysqlerror.swf