Apache Friends Support Forum

How do I create a MySQL database on my site using phpMyAdmin?

Click on Databases in the top menu bar.

Can I ask another one? When I try to connect to the newly created database (no tables, etc), It asks for a database user and password. I didn't set up anything when I created it. I wasn't given the opportunity. So I can't connect because I don't have them. Is there some kind of default I don't know about?

by default your mysql server does have a user named "root" without any password.
You can use this, or you can create another one in the phpmyadmin tab permissions if needed

It is not advisable or best practice to use the 'super user root' for your database, create a new user and leave user root for System use only or you could create a security risk.



Click on Privileges and select Add a new user.

When you have added your user click on Generate - do not add privileges yet.

Once you have done that then go back to the Home page and select privileges again and find the user you created and select the edit icon on the end of the line,

This is where you add privileges for that user for the database you created only.

This old post by my dear friend Izzy did a tutorial type post for creating a Wordpress database and although phpMyAdmin has changed slightly the general gist of the information is the same and may help especially if you copy and paste the content to a text file for future use.
viewtopic.php?p=112258#p112258


We will have you all sorted soon.

Sorted now, thank you both very much!!!

Now to get Open-Realty to do 1/4 as well! That's a stretch.

Cherrio!

Oh, that may be only from when I lived in New Zealand, and doesn't apply to Australia. Anyway, you get the picture!

Thanks for the feedback.

Cheerio.