View previous topic :: View next topic |
Author |
Message |
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Sun Feb 09, 2003 10:03 pm Post subject: Guide: How to Install MySQL |
|
|
Introduction
MySQL is a very popular database server and most scripts which rely on
a database give MySQL the respect that it deserves... You can find out
more about MySQL by going to the following address
http://www.mysql.com
Requirements
1. Abyss Web Server
2. MySQL
3. WinZIP
Installation Steps
1. Create a new directory in the Abyss program root directory
(not htdocs) called database.
2. Create a new folder inside database called mysql. You're
setup should probably now look like the following:
X:/Program Files/Abyss Web Server/database/mysql
Please Note:
Replace X:/ with your actual system path, C:/ or D:/, etc... Also,
make sure to place database/mysql into your Abyss path.
3. Unzip and Install MySQL into the new database/mysql
folder.
4. Create a new text file and copy the following and paste it
into your new text file.
Code: | [mysqld]
basedir=X:/Program Files/Abyss Web Server/database/mysql/
datadir=X:/Program Files/Abyss Web Server/database/mysql/data/ |
Please Note:
Replace the values for basedir and datadir with the
paths to your installation if on another partition or if in another
directory... The file should probably now look like the following:
Code: | [mysqld]
basedir=C:/yourpathto/Abyss Web Server/database/mysql/
datadir=C:/yourpathto/Abyss Web Server/database/mysql/data/ |
5. Save the new text document as my.ini and save it in
either your C:\WINDOWS or C:\WINNT directory.
Re-cap
So far MySQL is installed into the database/mysql folder and you saved
a "my.ini" file into the WINDOWS/WINNT directory... Excellent!
6. Navigate your way into the database folder > mysql > bin and
launch winmysqladmin.exe
Final Step
Upon launching that file you should now see a traffic signal in your
system tray... Is the light green? Excellent you have MySQL ready to
serve...
TIP
MySQL is a fabulous server but requires plenty of command line
knowledge. Fortunately theirs a really nice GUI in php for it called
phpMyAdmin. Check out the following thread for a quick guide on
installing phpMyAdmin.
http://www.aprelium.com/forum/viewtopic.php?t=1071
Good luck :) _________________ Victor B. Gonzalez
http://aeonserv.com
Last edited by vbgunz on Wed Apr 02, 2003 7:52 pm; edited 3 times in total |
|
Back to top |
|
|
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Sun Feb 09, 2003 10:24 pm Post subject: Please report errors in a reply to this post... Thank You |
|
|
This guide was put together in minor haste... Though I triple checked it for errors I at times felt very overwhelmed with it considering I am extrememly busy at the moment with plenty of work on my hands... If you find errors please post them, if you have comments, questions and or problems please post them... I will appreciate anyone also telling of their experience in following these quick guides...
Thank you for your time :) _________________ Victor B. Gonzalez
http://aeonserv.com |
|
Back to top |
|
|
kinjoJake -
Joined: 08 Feb 2003 Posts: 23
|
|
Back to top |
|
|
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Mon Feb 10, 2003 10:16 pm Post subject: vbgunz |
|
|
Powerful!... Thank you... It'll keep the W2K users from popping the question "I can't find my C:\WINDOWS directory..." Very cool KinjoJake, thanks :) _________________ Victor B. Gonzalez
http://aeonserv.com |
|
Back to top |
|
|
kinjoJake -
Joined: 08 Feb 2003 Posts: 23
|
Posted: Mon Feb 10, 2003 10:20 pm Post subject: |
|
|
Thank you for posting it.
Can you tell me where this is.
If this was simple read how easy it is to install a much needed GUI
for MySQL which will help you administrate your database server.
In my MyODBC box this is there -
[Not Found]
[Driver 3.51 Not Found]
Any ideas on this?
I believe his has to be changed:
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/mysql/
datadir=C:/Program Files/Abyss Web Server/database/mysql/data/
To:
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/
datadir=C:/Program Files/Abyss Web Server/database/data/
|
|
Back to top |
|
|
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Mon Feb 10, 2003 10:47 pm Post subject: MySQL, ODBC, Installing, Configure |
|
|
What I refer to as the much needed GUI for MySQL is phpMyAdmin... You can read up on that guide by going to this link... http://www.aprelium.com/forum/viewtopic.php?t=1063
Quote: | I believe his has to be changed:
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/mysql/
datadir=C:/Program Files/Abyss Web Server/database/mysql/data/
To:
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/
datadir=C:/Program Files/Abyss Web Server/database/data/ |
You're correct... I failed to mention that though you create a new folder called database in the Abyss root directory to create anoter one called mysql...
Good looking out on that one ;) I'll see if I can change it...
If I can't change it people reading this qho just went through the guide just follow what KinjoJake said... Thank you KinjoJake :)
Quote: | In my MyODBC box this is there -
[Not Found]
[Driver 3.51 Not Found]
Any ideas on this? |
Sorry bud wish I can help you... Until I come across the error myself I haven't seen it yet :(
Thanks for helpign me out with making this guide sharper... It's people like you who make quick install guides like these a better quality :)
Thanks again for pointing it out :) _________________ Victor B. Gonzalez
http://aeonserv.com |
|
Back to top |
|
|
kinjoJake -
Joined: 08 Feb 2003 Posts: 23
|
Posted: Tue Feb 11, 2003 2:07 am Post subject: |
|
|
Can you figure this one out?
I can't get a green light if i add the folder [mysql].
I tried uninstalling it completly and rebooting 3 times.
Edited the my.ini. Nothing worked
Went back to how i did it the first time [without the mysql folder] and it works.
|
|
Back to top |
|
|
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Tue Feb 11, 2003 2:11 am Post subject: |
|
|
Quote: | You're correct... I failed to mention that though you create a new folder called database in the Abyss root directory to create another one called mysql... |
I said in my post just a few minutes after yours that you were correct and that I forgot to mention to add the mysql folder...
I also added that detail to the guide along with WINNT and put in a thank you for it :)
Sorry for any inconvience :( _________________ Victor B. Gonzalez
http://aeonserv.com |
|
Back to top |
|
|
kinjoJake -
Joined: 08 Feb 2003 Posts: 23
|
Posted: Tue Feb 11, 2003 3:04 am Post subject: |
|
|
Please read my above post. Thank you.
|
|
Back to top |
|
|
vbgunz -
Joined: 02 Feb 2003 Posts: 615 Location: Florida
|
Posted: Tue Feb 11, 2003 3:44 am Post subject: |
|
|
I understand it didn't work for you the first time because I said to install MySQL into the database folder... I left out having to create another folder called "mysql"... So the way you solved it was the only solution for you...
As to why it didn't wish to work when you created the new mysql folder inside the database directory can only mean one of three things...
you created the folder but didn't move mysql and all of its files to the new "mysql" directory or you never deleted the my.ini or you did but wrote into it the wrong values that pointed to your database/myql...
I have my setup to the point where I can move my database to anywhere on the harddrive and only have to update the my.ini... I do not have the answer as to why it didn't work for you...
The only answer I have is at first my guide left out that very tiny detail which should have caused some really big problems... Sorry but thanks and its fixed now... _________________ Victor B. Gonzalez
http://aeonserv.com |
|
Back to top |
|
|
|