How do I create a MySQL database in phpMyAdmin (SOLVED)

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: XAMPP Language

Postby Raas » 06. October 2011 22:57

How do I create a MySQL database on my site using phpMyAdmin?
Raas
 
Posts: 6
Joined: 03. September 2011 04:03

Re: XAMPP Language

Postby Sharley » 06. October 2011 23:01

Click on Databases in the top menu bar. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP Language

Postby Raas » 06. October 2011 23:19

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?
Raas
 
Posts: 6
Joined: 03. September 2011 04:03

Re: XAMPP Language

Postby Altrea » 06. October 2011 23:24

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP Language

Postby Sharley » 06. October 2011 23:31

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. :shock:



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. :D
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP Language

Postby Raas » 07. October 2011 00:01

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!
Raas
 
Posts: 6
Joined: 03. September 2011 04:03

Re: How do I create a MySQL database in phpMyAdmin (SOLVED)

Postby Sharley » 07. October 2011 00:44

Thanks for the feedback. 8)

Cheerio. :D
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 127 guests