mysql privileges major issue

[selfinfliction]

i have recently switche dover to plesk from cpanel and am having some serious issues with the databases. i cannot import a database no matter what i try.. this is what i have done so far:

in plesk created domain, created database created database user, went into phpmyadmin and landing page says "no privileges" right below create new database. i go to import and after it looks like the database has transferred it gives me this error:

#1044 - Access denied for user '[username]'@'%' to database '[database_name]'

how do i fix this issue? i tried reading some of the documentation with phpmyadmin but i'm not a programmer, i don't understand 1/10 of what they are talking about. on cpanel all i had to do was click create user, grant all permissions and it was done. i have absolutely no idea how to give a user permisions when there are no options for it.

any help would be greatly appreciated

 

[Whistler]

Originally posted by selfinfliction
i have recently switche dover to plesk from cpanel and am having some serious issues with the databases. i cannot import a database no matter what i try.. this is what i have done so far:

in plesk created domain, created database created database user, went into phpmyadmin and landing page says "no privileges" right below create new database. i go to import and after it looks like the database has transferred it gives me this error:

#1044 - Access denied for user '[username]'@'%' to database '[database_name]'

how do i fix this issue? i tried reading some of the documentation with phpmyadmin but i'm not a programmer, i don't understand 1/10 of what they are talking about. on cpanel all i had to do was click create user, grant all permissions and it was done. i have absolutely no idea how to give a user permisions when there are no options for it.

any help would be greatly appreciated

Youre actually not supposed to be able to create new databases using phpMyAdmin - you should solely use Plesk to create new databases and tie it together with the domain it's needed for.

If you need to create databases outside the Plesk system - you need to look at the MySQL manaual about granting access and privileges [1].

But if you don't know what your'e doing - I really suggest you keep using Plesk to add new databases and database users as Plesk will setup the normal privileges on each created account.


[1] http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html

 

[sloppy robot]

did this get figured out? im having the same problem.. if you set up a database, it wont let you import one of the same name, if you set up a diferent name, it wont import a database.. how is everyone importing?

 

[Whistler]

Why import a database - why not just import the tables into a database already created and setup correct through Plesk?

 

[sloppy robot]

thats a good question.. ill have to learn how to import tables.. i only know how to export and import full databases right now

 

[Whistler]

But this is really not a Plesk issue - but a question about learning either phpMyAdmin or MySQL itself...