Web Hosting Talk







View Full Version : Plesk & phpMyAdmin Confusion


dac9
10-18-2007, 09:00 PM
Hey Guys,

I wanted to start by saying I just moved to a dedicated server from a VPS. I have 1 dedicated machine at SoftLayer & wanted to say WOAH... There servers and network is amazing. So keep up the great work guys...

Anyway I am using Plesk 8.2.1 on RHEL 5. I am having trouble importing .sql files into my domains... WebAdmin provides a shortcut to phpMyAdmin but it seems I dont have the correct priv to import a database.

So... is there a way to launch phpMyAdmin without using plesk so I can be a superuser or am I going about things the wrong way...

Below is exactly what I have done and the error it gives me:

I have exported a .sql file and I am importing this file into a DB on my new server. im using the DB WebAdmin tools that basically opens a restricted phpMyAdmin window.

When I import the .sql file into a DB using the WebAdmin phpMyAdmin I recieve the following error:

"MySQL said:
#1044 - Access denied for user 'snuck'@'%' to database 'phpbb'"

How can I be an admin user for this... I thought i was... I dont know how to open the full PHP my Admin... is it possible with an installation of Plesk?

I look forward to your responses...

activelobby4u
10-21-2007, 06:58 AM
Hey Guys,


So... is there a way to launch phpMyAdmin without using plesk so I can be a superuser or am I going about things the wrong way...


"MySQL said:
#1044 - Access denied for user 'snuck'@'%' to database 'phpbb'"




To manage the database with phpmyadmin, its best suggested to install another instance of phpmyadmin in your server . This URl should help you

http://forums.theplanet.com/index.php?showtopic=56014

With regards to the error you are receving, please try adding the user to the database phpbb and make sure you are not trying to update the database from a phpmyadmin running in a remote machine

amex
10-21-2007, 03:21 PM
There is no way to access phpmyadmin outside of the plesk CP without installing a seperate instance of phpmyadmin.

Phpmyadmin is just a software that lets you use a gui to manage mysql databeses so it can be installed anywhere just needs to be given: IP address, username & password of the mysql server.