Guide: How to Install MySQL

Tempman · - Joined: 26 Oct 2003 Posts: 1 Location: London, UK

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:

Toadhead · - Joined: 01 Dec 2003 Posts: 21

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 · - Joined: 17 Jan 2004 Posts: 50

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 · - Joined: 15 Sep 2003 Posts: 130 Location: GREEN BAY

Thanks again Aprellium!

WNA · - Joined: 25 Jan 2004 Posts: 10 Location: Essex

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 · - Joined: 22 Mar 2002 Posts: 6800

WNA,

WNA · - Joined: 25 Jan 2004 Posts: 10 Location: Essex

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

Xavier · - Joined: 17 Jan 2004 Posts: 50

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 · Posted: Tue Jan 27, 2004 6:04 am Post subject:

hmmm interesting maybe i might run mysql
_________________
living in an armish paradise.....no gates here!

mawuahahaha :)

WNA · - Joined: 25 Jan 2004 Posts: 10 Location: Essex

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

WNA · - Joined: 25 Jan 2004 Posts: 10 Location: Essex

Infernus · - Joined: 14 Mar 2004 Posts: 16

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 · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 14 Mar 2004 Posts: 16

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 · - Joined: 04 Apr 2004 Posts: 1

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 · - Joined: 05 Apr 2004 Posts: 1

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
_________________
------------------------------------
Who said the Grim was Male

iNaNimAtE · Posted: Tue Apr 06, 2004 1:13 am Post subject:

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.
_________________
Bienvenidos!

demonhunter · - Joined: 14 Jun 2003 Posts: 79

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 · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 22 Apr 2004 Posts: 16

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 · Posted: Tue Apr 27, 2004 3:14 am Post subject:

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.
_________________
Bienvenidos!

goku112 · - Joined: 22 Apr 2004 Posts: 16

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 · Posted: Wed Apr 28, 2004 5:25 am Post subject:

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:

coolboi · - Joined: 07 Jun 2004 Posts: 7

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 · - Joined: 25 Apr 2003 Posts: 993 Location: Wiltshire, UK

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
_________________
Olly

Ang88 · - Joined: 30 Jun 2004 Posts: 11

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 · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 18 Jul 2004 Posts: 18

iNaNimAtE · Posted: Mon Jul 19, 2004 1:21 am Post subject:

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

widox · - Joined: 04 Aug 2004 Posts: 1

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)

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 17 Aug 2004 Posts: 1 Location: Lubbock

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 · - Joined: 29 Aug 2004 Posts: 2

green light
thanx alot

336323287 · - Joined: 01 Aug 2004 Posts: 1

Thanks a lot!

Xanathos · - Joined: 10 Sep 2004 Posts: 4

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 · - Joined: 04 Jul 2004 Posts: 609

Your using Apache right? BURN HIM...-ahem-

Try turing off force-cgi-redirct in php.ini
_________________

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 04 Jul 2004 Posts: 609

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 · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 04 Jul 2004 Posts: 609

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 · - Joined: 13 Apr 2004 Posts: 487 Location: Canada

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 17 Aug 2004 Posts: 5

Is it possible to run Movable Type without sql?

Xabora · - Joined: 05 Jun 2003 Posts: 3

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 · - Joined: 09 Dec 2004 Posts: 2

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:

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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 · - Joined: 09 Dec 2004 Posts: 2

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:

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

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

Spiritmouse · - Joined: 28 Dec 2004 Posts: 1

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 · - Joined: 02 Dec 2004 Posts: 194

Use ctrl+alt+dlt and check your processes. If you see something with mysql in it then its running.
_________________
int main() {
cout << "Im Pro Apache";
cin.get();
}