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 🙂

fusion137

Thanks for a very clear and concise guide to installing mysql. as a complete novice, i managed without a single problem. thanks again

oMeGa DrAgOn

this is great! as i love using this server software but i needed mysql as im using it on my comp to develop a script called Phoenix Bulletin Board (pBB) 8)

frandy

hallo,
i've got this red light problem, everything i tride, nothing was a help.
when i open the winmysqladmin i get a red light. sou i click left on the it an chose start this service i get this message: fails to start... please wait 30 s...
i get also myodbc not found the tabs my server and variables is empty
i would by glade if someone could help me

live_u4

I also had the red light. Tried everything and nothing but... I got the key!!!! In my case, it was a bad character in the my.ini file
I had:


[mysqld] 
basedir=C:[b]\[/b]xpath[b]\[/b]database[b]\[/b]mysql
datadir=C:[b]\[/b]xpath[b]\[/b]database[b]\[/b]mysql[b]\[/b]data\

Instead of:


[mysqld] 
basedir=C:[b]/[/b]xpath[b]/[/b]database[b]/[/b]mysql[b]/[/b]
datadir=C:[b]/[/b]xpath[b]/[/b]database[b]/[/b]mysql[b]/[/b]data[b]/[/b]

Perhaps, this is the reason some guys when re-installing with default parameters made it work. Also, i guess this is one of the most common problems with mysql connection tru PHPmyAdmin

live_u4

I also had the red light. Tried everything and nothing but... I got the key!!!! In my case, it was a bad character in the my.ini file
I had:
Code:
[mysqld]
basedir=C:\xpath\database\mysql
datadir=C:\xpath\database\mysql\data\
Instead of:
Code:
[mysqld]
basedir=C:/xpath/database/mysql/
datadir=C:/xpath/database/mysql/data/
Perhaps, this is the reason some guys when re-installing with default parameters made it work. Also, i guess this is one of the most common problems with mysql connection tru PHPmyAdmin

x19

hello...
can somebady show me..??
how can i install mysql on linux??
i have install it before but it can't work... :cry:
pleaseee.....some-one...... :wink:

aprelium

x19, the best place to get step-by-step instructions on how to setup MySQL on Linux is the documentation of MySQL on http://www.mysql.com .

si_pb2002

When i put that in my web browser ^^^
I get this >>>
"Security Alert! The PHP CGI cannot be accessed directly.
This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.
For more information as to why this behaviour exists, see the manual page for CGI security.
For more information about changing this behaviour or re-enabling this webserver, consult the installation file that came with this distribution, or visit the manual page."
Ive looke dat the links mentioned but im stumpped as to what i need to change to get it working?

aprelium

si_pb2002,
You have this message because you haven't installed correctly the PHP support in Abyss as described in http://www.aprelium.com/abyssws/php.html . Check especiallt the CGI environment variable REDIRECT_STATUS declaration. Its name shouldn't have any spaces before or after.

Ch1ck3n^

vbgunz : i have the green light on the admin stuff and when i then tryin to configure the pbpbb2 i get this (common) problem:

phpbb2 wrote
phpBB : Critical Error
Could not connect to the database

And when i start the admin prog. on the server it says

MySQL wrote
Not Found
Driver 3.51 Not Found

What is the problem?

Tempman

Something i overlooked is the error file! This is very easy to miss since in WinMySQLAdmin, when you click the "Error" Tab the text field is blank! (A bug... :roll:) However it isn't! This should help you fix any red-light problems. It is located:
X:/Path/mysql/data/
(Replace "X:" with your driver letter and "Path" with the path to the mysql directory)
e.g. C:/Program Files/Abyss Web Server/mysql/data/
You can tell which file is the error file because it has the file extension .err
The error file should tell you what needs to be done. For example, I wasn't able to get a Green Light (Ever) but then I looked at error file and got this:

031031 16:21:55 InnoDB: Started
031031 16:21:55 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
031031 16:21:55 Aborting

I accidently deleted the database "mysql" which the program seems to need. Once I re-added it (from my zip file) it was Green Light all the way!
I hope this helps some people 😃

Toadhead

Tempman...you are fantastic, It FINALY works!!!!!!!!!!!!!!!!!
Hint to every mySQL user: DON'T REMOVE THAT MYSQL FOLDER IN mysql/data or just don't remove the database mysql when you login at phpmyadmin.
Toadhead

Xavier

i cant get the green light!! i have been trying for hours and i do not see anything that i have done wrong!! could someone please help me!

lestat

Thanks again Aprellium!

WNA

The Guide worked, where it says 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=10 , is this nessecery to install?
Im getting these errors:
The server cannot start because of the following error(s):
* Cannot open/create the log file.
* Cannot open/create the CGI error file.

aprelium

WNA,

WNA wrote
Im getting these errors:
The server cannot start because of the following error(s):
* Cannot open/create the log file.
* Cannot open/create the CGI error file.

It seems that you changed the Server Root. So create an empty directory called log in this new server root and restart the server.

WNA

I have a red light on the winMySQLadmin. What have i done wrong?

Xavier

when i was trying to configure mysql i dont know what was wrong but i tried uninstalling mysql and then YOU MUST DO THIS:i went to the c:/windows directory and deleted my.ini file (this file might be hidden so u better just do a search of the windows folder. Then i downloaded mysql again and when the first window that asks u for a password and user comes up make sure to type in Admin(or any username) and a password. U MUST DO THE USER AND PASS WINDOW BEFORE MYSQL CAN CONFIGURE ITSELF!

goose

hmmm interesting maybe i might run mysql

WNA

Im getting a red light why? I followed ALL the instructions.

« Previous Page Next Page »