Guide: How to Install MySQL

vbgunz · 2003-02-10T16:41:57+00:00

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. [mysqld] basedir=X:/Program Files/Abyss Web Server/database/mysql/ datadir=X:/Program Files/Abyss Web Server/database/mysql/data/ if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 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: [mysqld] basedir=C:/yourpathto/Abyss Web Server/database/mysql/ datadir=C:/yourpathto/Abyss Web Server/database/mysql/data/ if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } 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 🙂

ninaxyz

How can I prevent multiple back-ups getting created to every text or picture file? I have XP operative and Office Software. Back-ups of a picture file I create keep getting generated as I try to delete them. Please advise how to stop this unnecessary multiplication.

aprelium-support

Ch1ck3n^ wrote

MySQL wrote
Not Found
Driver 3.51 Not Found
What is the problem?

The error message is pretty much self explanatory: there is obviously a problem with your MySQL setup. We strongly suggest that you use the latest MySQL installer that takes care of the driver setup and its associated programs. The latest MySQL series is now 5.x and 3.51 is obsolete and no more supported (even by its authors.)

DonQuichote

As you are installing MySQL for Windows, you'd want to fix the configuration bug on windows. By default, MySQL cripples all table names to lower case. This is the worst thing to do as a "work-around" to case sensitivity on Linux. The correct way to handle table names is case INsensitive, but keep the case as it is. To make MySQL get the tables right, add the following line to my.ini:

[mysqld]
lower_case_table_names=2

Do so before you create any table, so directly after runing the installer.

« Previous Page