Installing MySQL

[Eagle]

Is there anyone here who has ever done this? I'm having a bit of trouble.

 

[Malcolm]

What os?
What webserver?
Are you compiling it?

 

[Eagle]

Windows XP, Local, Nope. Basically, I just want a version I can test scripts with but if I just host a local version, can I get the stuff on the web to read it from my local drive? What would the host be?

Basically what I'm saying is I have some web space on a linux server with PHP, but I dont have a MySQL account. However I'm designing a page using MySQL and I need to test the scripts before I upload them to the server they are supposed to be on.

 

[Hacktarux]

install easyphp
it contains apache, mysql, php, phpMyAdmin and everything is already configured to work together

Then if you don't want to mess with aliases you put your files into www/ folder inside easyphp folder. Once the server is launched, to view the result, look at this address: http://localhost

That's all i think

 

[Martin]

Here's a great tutorial for setting up Apache, MySQL and PHP on Windows. I've used it myself, and I had everything running in like 15 minutes.

http://www.vbulletin.org/forum/showthread.php?s=&threadid=39482

 

[Eagle]

Well since I already have PHP, MySQL, and Apache downloaded, and I'm still on a dial up, I opted for martins version. thanks for the help.

 

[Eagle]

OK, got it all set up, but how do I find the MySQL host, password, and username?

 

[Hacktarux]

host=localhost (even on a real server it's usually localhost)

You have to choose a user name, a database name and a password

then launch the mysql client (should be mysql.exe) and type the following commands:

create database name_of_your_database;

grant select,insert,update,delete,create,drop
      on name_of_your_database.*
      to name_of_your_user@localhost
      identified by 'your_password';

quit

It should create everythings you need.

You can also install phpmyadmin, it's a php script that'll enable you to do this in a gui.

 

[Eagle]

ok, thanks. The sql database I used were already set up and I only had access to one database so I never learned how to create them.

 

[Eagle]

aparently the post method isnt working properly now. Its not passing any of the variables from the forms.

 

[Eagle]

nevermind, SJR helped me out on IRC.

 

[Lex]

i recommend you to use phpmyadmin to manage your mysql databases and mysql users

 

[Eagle]

Yeah the school has that on their server. Either they didnt install it right or its just messed up cause its always creating poor sql commands.

 

[Eagle]

OK, I got phpMyAdmin up and running. It seems to be working. Thanks for the tip.