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 🙂

WNA

Tempman wrote
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 😃

Im getting this error
C:/Program Files/Abyss Web Server/mysql/data - Bad Path
In the documents path what do i type in?

Infernus

Well, im trying to run it with abyss on win98. everytime it starts its slows everything down, and i have no green light. Aslo where it says MyOBDC, it says not found, driver 3.51 not found. what does this mean?

TRUSTAbyss

You may want to try uninstalling MySQL and delete my.ini
and try installing it over again using http://os17fan.cjb.net
my.ini is in C:\Windows

Infernus

Alredy tried. I have looked at error log and this is what i get
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to section 3.1 of
InnoDB: http://www.innodb.com/ibman.html
040330 22:12:21 Can't init databases
040330 22:12:21 Aborting
040330 22:12:21 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040330 22:12:21 C:/MYSQL/bin/mysqld-opt.exe: Got signal 11. Aborting!
040330 22:12:21 Aborting
Over and over. Also the winMyadmin seems to be locking

peasant

This tutorial is so helpful, perhaps you would consider having it on the main site to compliment the ones on how to install php, perl etc.

ThegrimReaperette

Right. Please help
I have instsalled MySQL and the green light is on
I also decided to test the SQL database by downloading a shoutbox
BUT
I have run the server with a Index file that uses the SQL database but i get an error saying
"Shout couldnt be added to database"
HELP

iNaNimAtE

This could be one of multiple problems:
1. You configured the shoutbox to access a database that doesn't exist,
2. The shoutbox is not configured with a user that has "write" priviledges,
or
3. This shoutbox doesn't work; get a new one.
I suggest troubleshooting the first two before you look on to another one.

demonhunter

I still got the read light i did what i saw in the picture that was on ur site is there anything else i needed to do?

TRUSTAbyss

I have ran into a problem before that had something to do with
Windows services using MySQL , all you need to do is make sure
mysql-nt.exe is loaded , it could be your services.
If you need any more help
meet me on MSN if you have it
and I will configure it for you , Free!
MSN MESSENGER: trustpunk@hotmail.com

goku112

isnt there a way i could create a db without phpMyadmin, thats what i want to know, cuz i dont have internet right now, so i have been downloading stuff on to a diskette and transmitting them to my hd, so could show this command line?

iNaNimAtE

Yes there is. I think all you have to do is go into the folder where you installed MySQL, go into "data," and create a new folder.

goku112

what do you do from there after creating the folder though? i mean , you probably need to set a username and password and stuff?

iNaNimAtE

Having a username and password is the same for all databases. It is a program-wide change. If you would like to set one without using phpMyAdmin, in your my.ini file, write:

[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=[yourpassword]

That is an example. Put your full path to the MySQL executable you use in the "Server" field, and put your desired password in the "password" field. Keep the user as root.

coolboi

hello
i m new to mysql i have downloaded mysql-4.0.20a-win as u said install in root directory of abyss web server but after installaition when i try to luanch winmysqladmin.exe an error say "A required .DLL file, LIMMYSQL.DLL, wasn not found." so what could be solution for my problem...
can u please help me out..
thank u

olly86

No need if you go to:
<Place MySQL installed>\lib\debug
you can copy the dll across to the dir (bin) and it should work.
read http://www.aprelium.com/forum/viewtopic.php?t=4566 for more info

Ang88

i read all the post on this topic, and i still can't seem to get the green light on. I reinstalled this thing 3 times now, and am just about to give up. Some one please help!
Also, when i right click, i goto Win NT, then start service, and i get that error that says "Fails to start the service..."

TRUSTAbyss

If you add me to your MSN or Windows Messenger buddy list , I
can help you install it , my MSN is trustpunk@hotmail.com
Note: My MSN is the same as my Windows Messenger
HELP HAS ARRIVED FOR YOU !

Mikke8

Ch1ck3n^ wrote
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?

Same Problem
but i'm newbie with the program
but where can i insert the tabels

iNaNimAtE

Download a utility called "phpMyAdmin" (use the "Tutorials" section). If you don't already, you need to add PHP Support.

widox

Hi guys. I need help , i installed mysql on my computer and i get the green light ok, then i installed phpMyAdmin, i think i have done all the steps with Abyss web Server. So when i try to access the database of mysql (http://localhost/phpMyAdmin/index.php) My browser attemps to download or open the file index.php
and when i do open the file, it automatically opens Dream Weaver software.
Something must be wrong! Sorry but my English isnt very good since i come from Chile (Spanish language)

« Previous Page Next Page »