How can i upload mysql database on my site?

[fifaros]

I tried using phpMyadin but it says i dont have privileges to create a database?

Here's the message i get.I suppose its a common problem but i m kinda newby in this field.


--
-- Database: `db_viso`
--
CREATE DATABASE `db_viso` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


ErrorMessage:

#1044 - Access denied for user 'fifaros'@'localhost' to database 'db_viso'

Can i get a little help here pls?
Thx in advance.

 

[garrettroyce]

You must use the MySQL Databases tool to create users and databases, as well as removing and adding permissions. I recommend using the MySQL Database Wizard tool.

 

[fifaros]

Well i did use MySql Databases to do that,i could create db and user but could not import my own db cause i didnt have privileges to create a db.

I saw a similar thread on this forum and remembered something a friend of me told
me the other day and i figured it out.Its pretty simple actually.

Using MySqlDatabases tool create a database with the same name as your own database.Create a user with all privileges and link your database to that user.

Then you just have to open your own "database.sql" file and remove these 2 lines from the code before importing it:

CREATE DATABASE `database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `database`;


By doing that,it wont try to create a database which you still dont have priviliges to do.It will import your database overwriting the one you created through MySqlDatabases before.

That's all.It worked just fine for me.

 

[garrettroyce]

Great! Let me know if you need anything else