Log in

View Full Version : MySQL: What to do?


Knyfe
03-06-2011, 05:55 PM
Ehh, I knew this was coming, but I figured I should finish uploading the files before I asked for help.

Sooo, I don't know anything about MySQL, and when I go to my website, here's what comes up:

Click here (http://pokemonorbit.net76.net/) to visit my site and see the error message.

Happens with every page, every time. I need to know MySQL.

Hall of Famer
03-06-2011, 06:03 PM
It appears that your database info was entered incorrectly when running the installer script, or the database itself may not exist at all.

Knyfe
03-06-2011, 06:04 PM
Is there anything specific I need to enter in the database? Because, when I made it, I made it and that's all. Like I said, clueless at MySQL.

EDIT: Oh wait, crap. I forgot to make the database. And it won't let me work on the site anymore, until a few hours later or something like that.

Hall of Famer
03-06-2011, 06:29 PM
umm you forgot to create a database? I believe this can be done in cpanel though, but you can definitely request help here if you dunno how to do this.

Knyfe
03-07-2011, 04:25 PM
I just made it; the same thing shows up. Is there anything I need to enter in the database?

fadillzzz
03-08-2011, 12:41 AM
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a7272356'@'localhost' (using password: NO) in /home/a7272356/public_html/inc/functions.php on line 13

By looking at the error message, it seems that you didn't provide the password for the database access. Therefore, the script couldn't connect to the database and creates an error message.

Hall of Famer
03-08-2011, 01:55 AM
Well yeah, thats a possibility. Also she may not have specified the correct database user, we will still need to know more info to help her further.

Knyfe
03-08-2011, 03:34 PM
I screenshotted whatever I think might be helpful. :3

http://i65.servimg.com/u/f65/15/55/73/97/scrnst10.png
__________________________________________________ ___________
http://i65.servimg.com/u/f65/15/55/73/97/scrnst11.png
__________________________________________________ ___________
http://i65.servimg.com/u/f65/15/55/73/97/scrnst12.png
__________________________________________________ ___________
http://i65.servimg.com/u/f65/15/55/73/97/scrnst13.png

ChibiMaestro
03-08-2011, 03:48 PM
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a7272356'@'localhost' (using password: NO) in /home/a7272356/public_html/inc/functions.php on line 13

^
Code copied and pasted from fadillz, you're supposed to put the USERNAME which would be:
a7272356_knyfe NOT a7272356

Knyfe
03-08-2011, 03:53 PM
Wait, what? You kind of lost me there. :desudesudesu: (I'm beginning to think I should practice more HTML before tackling jobs like this X3)

ChibiMaestro
03-08-2011, 03:55 PM
a7272356 is your account name,
a7272356_knyfe is your username. So replace "a7272356" with "a7272356_knyfe" XD

And no, this doesn't really have anything to do with HTML, but it helps your understanding. Don't worry, Mys will help you with every step you go :3

Knyfe
03-08-2011, 04:01 PM
Yesh, but in which file? Or in the database?

ChibiMaestro
03-08-2011, 04:04 PM
Urgh, I'm confused now....
o-o

Try config.php o-o

Hall of Famer
03-08-2011, 04:07 PM
In your config.php file, find this:


$dbname = 'a7272356';


Replace by:


$dbname = 'a7272356_knyfe';


See if it works.

Knyfe
03-08-2011, 04:09 PM
I click to edit config.php, but the whole file is completely blank. @.@ Nothing else in the files is like this. I uploaded it, opened it in DreamWeaver AND Notepad++, but nothing changed. :mii:

Hall of Famer
03-08-2011, 05:07 PM
umm the file is completely blank? Then you did not run installer script successfully. You might have entered wrong database info atm you installed this script.

Knyfe
03-08-2011, 06:06 PM
I went through the files individually; I'll re-download it and see if anything changes. (I can only download on the computer at my dad's house so it might take a while for any results.)

Hall of Famer
03-08-2011, 10:32 PM
Alright then Knyfe. You can always read Chibi's tutorials thread on how to create a Mysidia site with 000webhost.

Knyfe
03-11-2011, 12:52 PM
Yes, I have, but I don't trust FileZilla and it runs slowly on my computer.