Thread: Newbie MySQL Question
09-25-2002, 03:59 PM #1Newbie
- Join Date
- Aug 2002
Newbie MySQL Question
OK, I've installed the MySQL package from Pkgmaster. I now need to use PHPNuke on one of the accounts - to do this I assume I need to create a new user in MySQL. The only problem is I'm not sure how to do this. I've managed to set up MySQL on a dedicated server before but it took me a while and I was hoping someone could help me through this to save me a lot of foul ups.
Thanks in advance
09-26-2002, 03:24 AM #2Web Hosting Guru
- Join Date
- Feb 2002
- The Netherlands
Install phpmyadmin. http://www.phpwizard.net/projects/phpMyAdmin/index.html
It is very easy to set it up. Basically untar the bunch, edit the config.inc and enter your root password.
Then over the web go to that location and there..... you have an easy way to create and maintain users and database.
Very easy package and contains a clear readme. !
Reliable hosting and Colocation
09-28-2002, 09:13 AM #3
Create a new user in MySQL via PhpMyAdmin
Create the new database
Go into the 'grants' section and edit the permissions for the previously created user. Make sure you do not give them 'grant' 'reload' or 'shutdown'
Sometimes MySQL can be a little flaky with this, so if it still gives an error delete the user and go back through the operation from A to Z again. Using PhpMyAdmin it should only take a minute.Blacknight
ICANN accredited domain registrar