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 🙂

siralex205

I dont have mysql admin on my computer when i installed mysql :(

siralex205

ok i opened mysqladmin.exe but it just closed instantly so i went into the cmd and did the cd stuff and accessed it. But when i do it just says a bunch of options but no traffic light at all :( Please help me.

andym01480

Hi
Followed your steps, but I think they are out of date and I don't know enough to know what to do!
winmyssladmin does not exist in mysql5.0- it was apparently removed a couple of versions ago.
So I have Abyss web server at C:\Abyss Web Server
The mysql server at C:\Abyss Web Server\database\mysql
a my.ini file that has the contents...
[mysqld]
basedir=C:\Abyss Web Server\database\mysql
datadir=C:\Abyss Web Server\database\mysqldata
at C:\WINDOWS\my.ini
But note that Mysql has its own my.ini in its directory which has abunch of stuff in it!
I have created a quick test script in php
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
?>
And it returns
Fatal error: Call to undefined function mysql_connect() in C:\Abyss Web Server\htdocs\mysqltest.php on line 4
I have PHP 5.0 installed
There are no traffic lights - Abyss is a windows service as is mysql
The Abyss logo thingie is in teh system tray - is the traffic light part of that?
Help!

andym01480

Note to self and anyone else struggling!
The aprellium boys have preconfigured PHP 5.0 to work with abyss and mysql - see end of thread http://www.aprelium.com/forum/viewtopic.php?t=6470
Just need to try it and then fiddle with the mysql now it doesn't have winmysqladmin!
[/url]

olly86

the config program of MySQL can install a service for you, this program is run automatically after setup has finished.

BrandonK

I'm having an odd problem with my mySQL install. I've gone through the tutorial a couple times now and I have the same problem each time:
I install it, it works great. I even install phpmyadmin over it and all works well. Any time I restart mySQL, I can't connect though. On the Enviornment tab in winmysqladmin.exe, under MyODBC, it says "Not Found Driver 3.51 Not Found"
With no connection info. I did password protect my mySQL db via the phpmyadmin tutorial. Did I have to change anything in the winmysqladmin.exe configuration?
Any ideas? Thanks.
Brandon

jamesthemagician

I can't get any lights...
This does this work with 5.0 version, dosn't it?
Which type should I download- I downloaded "Without installer (unzip in C:\)" ("mysql-noinstall-5.0.19-win32.zip")
I can't find "winmysqladmin.exe" I can only find "mysqladmin.exe" and when I open this nothing happens, exept a flash of a command prompt like the other guys.
Do I have to open it via command prompt?
HELP! :(

Moxxnixx

jamesthemagician, winmysqladmin.exe is not included in MySQL anymore.
They've done away with the "traffic lights".
You should download the version with the installer and do a default installation.

silver silence

PLEASE HELP!!! i installed it in C:/program files/abyss web server/database/mysql/
i made the my.ini file and i did it right and saved it in C:\windows
but when i click the exe in the bin folder, no light comes up!! nothing!! not red or green!!! can someone please help? what did i do wrong? thanks!!
EDIT: i just read the above post, does that mean it works if nothing comes up except the flash of a command prompt? thanks

Panda200x

I've tried that time and time again and nothing works. No error messages but phpMyAdmin says MySQL is missing

MonkeyNation

Damnit, all of you forget about the green light.
On the assumption you're using windows NT or above, run mysqld-nt.exe, and check if it's still running in task manager after it forks.
If it is, congradulations it works, otherwise it sucks to be you.

AbyssUnderground

Or you could ignore nasty comments and go to www.abyssunderground.co.uk/tutorials-mysql4-0-24.php and www.abyssunderground.co.uk/tutorials-mysql4-1.php and get step by step instructions on installing and running MySQL.

Xichael

Wow, no replies in over 2 years? That's surprising, considering the info is uselessly outdated... Since the original author seems to be long gone, would someone who knows how to do this please start a new thread with the current recipe? And could that thread be the one that's linked to from the Abyss FAQ? I'd love to know how to set up Abyss with MySQL, and I'm sure I'm not the only one...

AbyssUnderground

Xichael wrote
Wow, no replies in over 2 years? That's surprising, considering the info is uselessly outdated... Since the original author seems to be long gone, would someone who knows how to do this please start a new thread with the current recipe? And could that thread be the one that's linked to from the Abyss FAQ? I'd love to know how to set up Abyss with MySQL, and I'm sure I'm not the only one...

If you did a forum search you'd find many new topics on the subject, and if you looked at the post before yours you'd see links to tutorials that work just fine.

Xichael

A forum search provides nothing (that I could find) in the way of instruction on how to install the current version of MySQL with Abyss, nor do your links, which are broken.
For a tutorial linked to from the FAQ, you'd expect the information to be of some use, but it's simply not - at least not with MySQL v5.
I wouldn't think it too much trouble for someone in the know to write up a fresh tutorial for the forum.

AbyssUnderground

Xichael wrote
A forum search provides nothing (that I could find) in the way of instruction on how to install the current version of MySQL with Abyss, nor do your links, which are broken.
For a tutorial linked to from the FAQ, you'd expect the information to be of some use, but it's simply not - at least not with MySQL v5.
I wouldn't think it too much trouble for someone in the know to write up a fresh tutorial for the forum.

See this image?

Its in every post I make and the link works fine. Click it and find out. It has up to date tutorials on just about everything you will need to run Abyss, MySQL, PHP, Perl, Mail Server, phpMyAdmin, etc etc etc. I hope it is of some use to you.

Xichael

Do the MySQL v4 tutorials on your site apply to v5?
Why not have the FAQ links direct there?

AbyssUnderground

Xichael wrote
Do the MySQL v4 tutorials on your site apply to v5?
Why not have the FAQ links direct there?

The tutorial for v4.1 is pretty much the same for v5. They don't change a whole lot and the installation is practically spelt out to you anyway with step by step instructions.

Xichael

So it's really just a matter of going with the default installation and using the configuration wizard?
These instructions really had me going down the wrong path.
The link to this thread really needs to be removed from the FAQ!
I hope someone with the ability to update it is reading this...

AbyssUnderground

Xichael wrote
So it's really just a matter of going with the default installation and using the configuration wizard?

Correct. Remember some people like to use old versions for their stability and compatibility, myself included.

« Previous Page Next Page »