MySQL noob guide
A lot of people have asked me on how to setup a MySQL server in windows. As most of you know I have switched to Linux. I don't know every step so correct me if im wrong.
Step one.
Download MySQL from
http://dev.mysql.com/get/Downloads/MySQ ... ql_mirror/
Step two.
Unzip it and rename the folder to MYSQL and place it into the root of your C:\ Drive.
Step three.
Go into C:\MYSQL\BIN and run the file called winmysqladmin.exe
Step four.
The basics are done, you might want to give a password to your root account some time. But untill then heres how you create a database with out using phpMyAdmin.
Go into the CMD window and use to following.
cd c:\mysql\bin
mysqladmin create <database>
<database> meaning the database name you want to use. So if you plan to use PHPBB then just tell the PHPBB installer to use your new database and it will do the rest.
Thats all toy need for a simple quick MySQL server. As long as you have phpMyAdmin set out of your WWWROOT you will be fine. If you want to use a remote connection to it then add a password to the root account. Just read the MySQL help for that.
Step one.
Download MySQL from
http://dev.mysql.com/get/Downloads/MySQ ... ql_mirror/
Step two.
Unzip it and rename the folder to MYSQL and place it into the root of your C:\ Drive.
Step three.
Go into C:\MYSQL\BIN and run the file called winmysqladmin.exe
Step four.
The basics are done, you might want to give a password to your root account some time. But untill then heres how you create a database with out using phpMyAdmin.
Go into the CMD window and use to following.
cd c:\mysql\bin
mysqladmin create <database>
<database> meaning the database name you want to use. So if you plan to use PHPBB then just tell the PHPBB installer to use your new database and it will do the rest.
Thats all toy need for a simple quick MySQL server. As long as you have phpMyAdmin set out of your WWWROOT you will be fine. If you want to use a remote connection to it then add a password to the root account. Just read the MySQL help for that.
Comments
Its my friends site (da FreeBSD king :P)
//Mr.Mac
I've found something useful there
-Q
No it's not doing it for WinWorld... But it may in the future....
I guess WinWorld got in on them when the going was good!
-Q
i get one there
-Q
That's old? That's not even a week ago!
-Q
-Q
WTH? TCP lives?
What do you mean by that? When you start the winmysqladmin.exe file it installs and starts the service. This is pretty much the same thing I used when I ran MySQL on my PC when I had windows.