View Full Version : SQL Database help....


MissMaura
04-20-2003, 01:59 PM
How do I figure out what version of MySQL I have...and why does it keep saying it can't connect to the database? I have no clue what I'm doing wrong...help please!!!

epolady
04-20-2003, 09:13 PM
You can ask your host or view their help pages about the version.

Chances are, that if you can't connect to a DB is that you didn't assign a user name & password to it. Check your MySQL settings again and make sure that you've both created a DB & set a user name & password so a user can access it. Good luck.

Jasper
04-20-2003, 09:38 PM
Are there any good tuts on using PHPmyAdmin, MySQL, and PHP? I just signed up for hosting and it has this. It would be a waste not to use it except for my forums ;D. thanks!

-Jasper

MissMaura
04-21-2003, 05:45 AM
It told me that the user name and password would be the same as the user name and password that are used for my ftp/menu login...so I have NO clue what else could be wrong.

epolady
04-21-2003, 06:51 AM
Do you have some sort of control panel where you can access and configure such things? Like email/mysql dbs, etc?

Make sure your user name & PW is correct. Also, is the DB name correct? Usually it looks like yourdomain_dbname or something like that, the user name usually looks something like yourdomain_yourname.

Are there any good tuts on using PHPmyAdmin, MySQL, and PHP? I just signed up for hosting and it has this. It would be a waste not to use it except for my forums ;D. thanks! -JasperThere's some good tutorial links here (http://www.lissaexplains.com/forum//showthread.php?s=&threadid=31529) & here (http://www.lissaexplains.com/forum//showthread.php?s=&threadid=32598). MySQL Tut (http://www.devshed.com/Server_Side/MySQL/Intro/page1.html) & Official Site (http://www.mysql.com). phpMyAdmin official site (http://www.phpmyadmin.net) Or perhaps a search on Google (http://www.google.com) can help you more.

MissMaura
04-21-2003, 04:25 PM
Yep I have a control panel...when I installed my database it told me that the user name was just the user name I use for my site, nothing else, and that the database name was just the name of my site.

it's also telling me I have no database selected...?

epolady
04-21-2003, 04:38 PM
What's telling you that you have no DB selected? What are you trying to install?

Did you create a user name/pw & added it to the DB?

Jasper
04-21-2003, 04:45 PM
Originally posted by epolady
There's some good tutorial links here (http://www.lissaexplains.com/forum//showthread.php?s=&threadid=31529) & here (http://www.lissaexplains.com/forum//showthread.php?s=&threadid=32598). MySQL Tut (http://www.devshed.com/Server_Side/MySQL/Intro/page1.html) & Official Site (http://www.mysql.com). phpMyAdmin official site (http://www.phpmyadmin.net) Or perhaps a search on Google (http://www.google.com) can help you more. [/B]

thanks, very useful links.

-Jasper

MissMaura
04-21-2003, 04:53 PM
I'm trying to install an XMB message board, and when I click the install button, it says there's no database selected. Before I tried to install phpBB mesage boards, but that told me it couldn't connect to the data base.

How do I create a new user name and password? When I installed the database, it told me that the user name and password would be the same ones used for my control panel...so that's what I used.

epolady
04-21-2003, 05:10 PM
You should be able to create a access user name & pw in your browser control panel. I think contacting your host would be more helpful, since they know about your account and they can tell you how to do things.