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 🙂

TRUSTAbyss

You need to first install PHP properly , to do that , you can either install
it using my PHP installation Tutorial at os17fan.cjb.net or you can use the
tutorial that Aprelium provided at aprelium.com/abyssws/php.html

blrellim

I've searched this forum for answers but could not find any. If I've skipped over something, please just direct to where the answer is. I've installed Abyss Web Server, php, phpMyAdmin, phpBB, and mysql. I have the green light with mysql, phpMyAdmin works (I am able to add, edit, etc. datbases and tables), php is working. The problem? I get an "Access Denied" error using the following script:
<?
$connection = mysql_connect("localhost","blrellim","*********");
die("Couldn't connect.");
if($connection){
$msg = "success";
}
?>
******** = my password.
My my.ini file looks like this:
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/mysql
datadir=C:/Program Files/Abyss Web Server/database/mysql/data
[WinMySQLAdmin]
Server=C:/Program Files/Abyss Web Server/database/mysql/bin/mysqld-nt.exe
QueryInterval=10
user=blrellim
password=*********
I have checked users in the mysql table wih phpMyAdmin and blrellim has all priveleges.
Can someone help me with why I'm getting an "Access Denied" error? The exact error produces:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'blrellim@localhost' (Using password: YES) in C:\Program Files\Abyss Web Server\htdocs\PHPmadeEasy\db_connect.php on line 2
Any help would be great.

sexyicon

green light
thanx alot

336323287

Thanks a lot!

Xanathos

Hello, I am a novice to this and I just got this consistent problem. Everytime I try to get to phpMyAdmin, everything seems fine, but it keep giving me this error:
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.
could someone help!!!

k1ll3rdr4g0n

Your using Apache right? BURN HIM...-ahem-
Try turing off force-cgi-redirct in php.ini

TRUSTAbyss

No he's not using Apache , this is displayed on any server , just follow the
instructions for installing PHP at www.TRUSTAbyss.com , enjoy Abyss :)

k1ll3rdr4g0n

wow stop spamming your site, why didnt you tell him to go here? http://www.aprelium.com/abyssws/php.html
You know theres a reason why Aprelium took time to make that page.
If I were admin I would ban people like you. (I so wish i was here.)
There is said it....most painless as possible.

TRUSTAbyss

I refered him to my website because I provide screenshots so its actually
easier to install PHP and for your information , im like a friend to them.

k1ll3rdr4g0n

OOO pictures, wow to bad though there outdated -sigh- and you dont need pictures to install stuff like PHP. Being a friend doesnt mean that they have to goto your site.

Foxified

k1ll3rdr4g0n wrote
OOO pictures, wow to bad though there outdated -sigh- and you dont need pictures to install stuff like PHP. Being a friend doesnt mean that they have to goto your site.

dont be jealous, he has a nice site, I followed it, its well described, and entertaining to read, and easy to follow pictures, the aprelium help is basic and crude..
you should also know, he provides LIVE help. which can be very good. and be very personal, live.

TRUSTAbyss

I wouldn't say that the aprelium PHP installation guide isn't a good one , I refered that
person to my website because he didn't know about the user environment variable with the
REDIRECT_STATUS , I explain in detail how to set it up , I just didn't want that user to
get lost , the chances of him actually viewing Aprelium's guide already is very high.

ccraft

Is it possible to run Movable Type without sql?

Xabora

I'm using IIS now... and by god when I was using Abyss the second part of the TUT helped me...
And now I have come back for its help...
Its that good of a TUT... be PROUD!

mr_dee

Ok, I have WinMySQLadmin, but I still get red lights, and when I try to enable the service manually in the services list (I am using Windows XP Home) it says the service terminated unexpectedly.
My my.ini looks like:

#This File was made using the WinMySQLAdmin 1.4 Tool
#09/12/2004 14:43:54
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/Program Files/Abyss Web Server/database/mysql
#bind-address=192.168.0.1
datadir=C:/Program Files/Abyss Web Server/database/mysql/data
#language=C:/Program Files/Abyss Web Server/database/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/Program Files/Abyss Web Server/database/mysql/bin/mysqld-nt.exe
user=frankie
password=<my password>

TRUSTAbyss

Do you have a firewall ? I found that some Firewalls will make MySQL red when you don't allow access to MySQL.
Also delete your my.ini , its all wrong , follow the MySQL tutorial after that. Below...
Abyss Web Server: Tutorials
www.TRUSTAbyss.com

mr_dee

It works, heres how I did it if anyone wants to try:
1: Delete your my.ini from your windows directory (either C:\WINNT or C:\WINDOWS)
2: Open winmyadmin, but when it asks you for a username and password, click cancel
3: in the my.ini editor in win admin enter the following code:

[mysqld]
# set basedir to your installation path
basedir=C:\Program Files\Abyss Web Server\database\
# set datadir to the location of your data directory
datadir=C:\Program Files\Abyss Web Server\database\data\

4: Close then re-open, and it should work.
(Thanks to TRUSTPunk for making me click cancel, and Mysql.com for the code snippet)

TRUSTAbyss

Actually , you don't have to edit any of the my.ini file. LateR!

Spiritmouse

Here's the thing. I follow the instructions to the letter. (Well not to the actual letter, but you get it) I open file: mysqladmin.exe but when I do I get a command screen and stuff flys by on it and then it closes itself. I don't get a green light, or for that matter a light at all. Can somebody /please/ help me figure this out?

Glitch2082

Use ctrl+alt+dlt and check your processes. If you see something with mysql in it then its running.

« Previous Page Next Page »