MySql Username/Password and config questions.

[Mhtml]

Ahhhh.... I'm tearing my hair out with this MySql stuff.

Firstly USERNAME AND PASSWORD? You define them where? Edit them where?

http://localhost will not work on my computer, how can I make MySql run from 127.0.0.1 ?

[bcarl314]

Well, first I'm going to point you to this thread.

http://www.codingforums.com/showthread.php?s=&threadid=11351

Next, I don't think you can access mysql using http, it typically uses port 3306. You'll need to use a program to access the D, or you can access from the command line.

In *nix just type
$> mysql -root
if it's your 1st time loggin in, I beleive it prompts you to set a user name and password, otherwise it will ask for a password, which you will need from the sysadmin.

To set up new accounts, check the documentation (manual.html) or try
$> man mysql
for information

You'll need to use the GRANT command to set up new users.

Once you set up users, you'll need to create a database. GRANT does not do that for you.

That's all I've got for now. Hope this helps.

[Mhtml]

I just edited the httpd.config or whatever it is and I got phpMyAdmin to work, I didn't know what is was until I got into it. And well... It's brilliant I created my database and assigned users to it and all. Now I have my forum running off localhost and I understand MySql a little better after reading a tutorial I found at google.

Also Morgoth is my host ;) lol, as you probably know he just installed MySql and so I'm going to attempt to use it.

[Nightfire]

The very latest version of phpMyAdmin allows you to do this very easily. It's just a page where you fill in the blanks :)

[Mhtml]

Well thanks to me being nosey and phpmyadmin being available I have gotten myself in trouble because I uploaded it, I didn't think about doing it from my computer. Anyway I caused a major security problem although nothing happened my host wasn't happy because something could have. And I would have yelled at me to.

Anyway I'm full of shame and going back to my darkness of my room to think about why I'm so stupid...