Guide: How to Install MySQL
Goto page Previous  1, 2, 3
 
Post new topic   Reply to topic    Aprelium Forum Index -> Tutorials
View previous topic :: View next topic  

Did this guide help you with your installation?
Yes - It Was Helpful
75%
 75%  [ 189 ]
No - But Helpful
6%
 6%  [ 16 ]
No - I've got problems
15%
 15%  [ 38 ]
Other
2%
 2%  [ 6 ]
Total Votes : 249

Author Message
Server One Host
-


Joined: 26 Dec 2004
Posts: 14

PostPosted: Wed Dec 29, 2004 8:23 pm    Post subject: Reply with quote

i dont have a winmysqladmin.exe , really.
_________________

Dont drop your baby yoshi!
Back to top View user's profile Send private message
uerjer5
-


Joined: 25 Nov 2004
Posts: 3

PostPosted: Sat Jan 08, 2005 5:57 am    Post subject: Reply with quote

yes i have the same problem as Server One Host i do not have a file named winmysqladmin.exe all i have is a file named mysqladmin.exe and when i run it i get a command screen that just flashes up and no imysql icon in taskbar and no process running any help plz
Back to top View user's profile Send private message AIM Address Yahoo Messenger
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Sat Jan 08, 2005 6:44 am    Post subject: Reply with quote

If your running on a Win9x version , I would recommend running MySQL in
the background , to do this go to C:\MySQL\bin and click mysqld_opt.exe.

Note: If this is a Windows NT type of Operating system , you should be able
to get away with just using the MySQL green light tray icon program. LateR!
Back to top View user's profile Send private message Visit poster's website
uerjer5
-


Joined: 25 Nov 2004
Posts: 3

PostPosted: Sat Jan 08, 2005 3:56 pm    Post subject: Reply with quote

im running winxp pro sp2 and like i said i dont have winmysqladmin.exe all i have is mysqladmin.exe and when i run it it only flashes a command screen then disapares thats all and i dont have mysql_opt.exe either
Back to top View user's profile Send private message AIM Address Yahoo Messenger
uerjer5
-


Joined: 25 Nov 2004
Posts: 3

PostPosted: Sat Jan 08, 2005 6:36 pm    Post subject: Reply with quote

ok i was using version 4.1 of mysql so i went and downloaded version 4.0 and it works so im just going to use it
Back to top View user's profile Send private message AIM Address Yahoo Messenger
FFLukeFF
-


Joined: 08 Jan 2005
Posts: 5

PostPosted: Tue Jan 11, 2005 11:02 pm    Post subject: Re: Guide: How to Install MySQL Reply with quote

vbgunz wrote:
Introduction
My file looks like the following:

Code:
[mysqld]
[mysqld]
basedir=C:\Program Files\Abyss Web Server\database\mysql
datadir=C:\Program Files\Abyss Web Server\database\mysql\mysql-standard-4.1.8-pc-linux-i686\data



6. Navigate your way into the database folder > mysql > bin and
launch winmysqladmin.exe



I dont seem to have winmysqladmin.exe there? Help! :(
Back to top View user's profile Send private message
NoName
-


Joined: 05 Jan 2005
Posts: 88
Location: Lawton America

PostPosted: Wed Jan 12, 2005 3:30 am    Post subject: Reply with quote

I believe its in 4.0 only...
_________________
-NoName
www.nonameproductions.us

Powered by Abyss Web Server
Back to top View user's profile Send private message Visit poster's website AIM Address
muka3d
-


Joined: 11 Nov 2003
Posts: 3

PostPosted: Sat Feb 19, 2005 12:13 am    Post subject: Reply with quote

Is there a guide for setting up MySQL 4.1?
Back to top View user's profile Send private message
Caduceus
-


Joined: 13 Mar 2005
Posts: 21
Location: Chattanooga, TN

PostPosted: Wed Mar 16, 2005 3:42 pm    Post subject: Green Light = Nada Reply with quote

Hi all,

I've been working on installing MySQL for days now. Here's what I've got:

Sony VAIO PII 400MHz w/Win98 (old isn't always a bad thing)
256Mb RAM
Abyss running on dedicated 10Gb drive
PHP

The first thing I did was try v 4 of MySQL...nothing...couldn't even get the traffic light icon in the systray

Removed that version and downloaded and installed v 5 of MySQL...VOILA!!! Grenn light!

NOW, I can't even get a username/password dialog in order to administer the program so I can't even get past the 1st step to using MySQL.

Anyone have any suggestions???

Thanks
Back to top View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
Viago
-


Joined: 16 Mar 2005
Posts: 2

PostPosted: Wed Mar 16, 2005 6:27 pm    Post subject: hummmm Reply with quote

ive installd MySql to C:\Program Files\Abyss Web Server\Database\mysql
created a MySql Database

Im using mysql-4.1.10a for Windows

when i run mysqladmin.exe
it just pops up and nothing happends, i didnt even catch what it said in comand prompt No green or red light
Back to top View user's profile Send private message
Viago
-


Joined: 16 Mar 2005
Posts: 2

PostPosted: Wed Mar 16, 2005 6:42 pm    Post subject: Reply with quote

k i was able to run the dos exe files throught Command.com

i copyed it over from the C:\windows\system_32 to the folder i wanted it in

it runs the files, but nothing happens, just alot of spamming lol
Back to top View user's profile Send private message
mufhaza
-


Joined: 31 Mar 2005
Posts: 1

PostPosted: Thu Mar 31, 2005 10:52 am    Post subject: Reply with quote

Hi,
i got green light for a few seconds and then it lights red again.
First thought was that Windows Firewall has blocked MySQL port - so i allowed this port to be opened - still changes to red.

In WinMySQLadmin1.4->Environment->MyODBC is shown error "Not Found". Question is - what is not found? There is nothing else written except "Not Found". I searched for *.err file and got nothing.
My.ini file seems to be correct.

(I use WinXP, Abyss Web Server, MySQL 4.1, MyODBC.)
What should I do!?
Back to top View user's profile Send private message
Amie
-


Joined: 07 Jun 2005
Posts: 23

PostPosted: Fri Jun 10, 2005 2:37 pm    Post subject: no green light Reply with quote

i followed your tutorial to the letter no green light when i did the ini file it asked if i wanted to replace the file said yes could that be why any ideas to how i can rectify this problem
Back to top View user's profile Send private message
Gripp
-


Joined: 14 Jul 2005
Posts: 2

PostPosted: Thu Jul 14, 2005 6:52 pm    Post subject: Reply with quote

I'm running my server as a windows service. I don't even have a taskbar icon. How do I know if MySQL is running? I assume it's not, since I can't seem to run mysql.exe succesfully...
Back to top View user's profile Send private message
Moxxnixx
-


Joined: 21 Jun 2003
Posts: 1226
Location: Florida

PostPosted: Thu Jul 14, 2005 7:06 pm    Post subject: Reply with quote

Gripp, welcome to the forums.
Open your Task Manager to see if mysqld-nt.exe is running.
Back to top View user's profile Send private message Visit poster's website
Gripp
-


Joined: 14 Jul 2005
Posts: 2

PostPosted: Fri Jul 15, 2005 2:33 pm    Post subject: Reply with quote

I can't get to my task manager :-[... it's a used computer, so every time I try to open the task manager it tells me that an my computer administrator has disabled it... even though I am a system adimn and have the only user account.
Back to top View user's profile Send private message
sccerguy
-


Joined: 18 Jul 2005
Posts: 10

PostPosted: Mon Jul 18, 2005 5:40 pm    Post subject: Reply with quote

ok i think i did everything right just when I run the config program and that last little part about the InnoDB or whatever and I tell it too go into database/mysql folder and hit next hit stops at the part where it is confirming the second thing what is wrong

i think it has something to do with the my.ini it is looking at the my.ini file not in where i put it IN WINDOWS but in the abyss web server folder
Back to top View user's profile Send private message AIM Address MSN Messenger
thebuzz
-


Joined: 25 Aug 2005
Posts: 6

PostPosted: Thu Aug 25, 2005 4:04 pm    Post subject: mysqladmin Reply with quote

ive installed mysql and i can not find any file called mysqladmin i have even used the file search with windows there just isnt a file called mysqladmin any were on my computer
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Thu Aug 25, 2005 4:06 pm    Post subject: Reply with quote

I think this is winmysqladmin you are looking for, it should be the one that looks like traffic lights.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Fri Aug 26, 2005 12:50 pm    Post subject: Re: mysqladmin Reply with quote

thebuzz wrote:
ive installed mysql and i can not find any file called mysqladmin i have even used the file search with windows there just isnt a file called mysqladmin any were on my computer

The new packages of MySQL (the one which size is around 14MB) does not contain MySQLAdmin. The new installer of MySQL takes care of setting the new root password.
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
siralex205
-


Joined: 11 Oct 2005
Posts: 13

PostPosted: Thu Oct 13, 2005 2:42 am    Post subject: Reply with quote

I dont have mysql admin on my computer when i installed mysql :(
Back to top View user's profile Send private message
siralex205
-


Joined: 11 Oct 2005
Posts: 13

PostPosted: Thu Oct 13, 2005 2:57 am    Post subject: Reply with quote

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.
Back to top View user's profile Send private message
andym01480
-


Joined: 09 Nov 2005
Posts: 2

PostPosted: Wed Nov 09, 2005 10:07 am    Post subject: Mysql and abyss Reply with quote

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!
Back to top View user's profile Send private message
andym01480
-


Joined: 09 Nov 2005
Posts: 2

PostPosted: Wed Nov 09, 2005 1:36 pm    Post subject: Reply with quote

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]
Back to top View user's profile Send private message
olly86
-


Joined: 25 Apr 2003
Posts: 993
Location: Wiltshire, UK

PostPosted: Thu Nov 10, 2005 12:26 am    Post subject: Reply with quote

the config program of MySQL can install a service for you, this program is run automatically after setup has finished.
_________________
Olly
Back to top View user's profile Send private message
BrandonK
-


Joined: 14 Apr 2005
Posts: 10

PostPosted: Sun Dec 04, 2005 11:10 pm    Post subject: Reply with quote

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
Back to top View user's profile Send private message
jamesthemagician
-


Joined: 14 Oct 2005
Posts: 32
Location: gloucestershire, uk

PostPosted: Sat Mar 25, 2006 6:38 pm    Post subject: Can't get anything Reply with quote

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! :(
_________________
This signature is getting old
Back to top View user's profile Send private message Visit poster's website
Moxxnixx
-


Joined: 21 Jun 2003
Posts: 1226
Location: Florida

PostPosted: Sat Mar 25, 2006 7:54 pm    Post subject: Reply with quote

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.
Back to top View user's profile Send private message Visit poster's website
silver silence
-


Joined: 26 Apr 2006
Posts: 14

PostPosted: Wed Apr 26, 2006 2:10 am    Post subject: Reply with quote

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
Back to top View user's profile Send private message
Panda200x
-


Joined: 30 Apr 2006
Posts: 2

PostPosted: Sun Apr 30, 2006 12:48 pm    Post subject: Reply with quote

I've tried that time and time again and nothing works. No error messages but phpMyAdmin says MySQL is missing
Back to top View user's profile Send private message
MonkeyNation
-


Joined: 05 Feb 2005
Posts: 921
Location: Cardiff

PostPosted: Sun Apr 30, 2006 1:05 pm    Post subject: Reply with quote

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.
_________________
Back to top View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger ICQ Number
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Sun Apr 30, 2006 2:26 pm    Post subject: Reply with quote

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.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Xichael
-


Joined: 23 Jul 2008
Posts: 4

PostPosted: Wed Jul 23, 2008 7:01 am    Post subject: Reply with quote

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...
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Jul 23, 2008 2:53 pm    Post subject: Reply with quote

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.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Xichael
-


Joined: 23 Jul 2008
Posts: 4

PostPosted: Wed Jul 23, 2008 9:49 pm    Post subject: Reply with quote

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.
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Jul 23, 2008 10:16 pm    Post subject: Reply with quote

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.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Xichael
-


Joined: 23 Jul 2008
Posts: 4

PostPosted: Wed Jul 23, 2008 11:17 pm    Post subject: Reply with quote

Do the MySQL v4 tutorials on your site apply to v5?
Why not have the FAQ links direct there?
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Jul 23, 2008 11:19 pm    Post subject: Reply with quote

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.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
Xichael
-


Joined: 23 Jul 2008
Posts: 4

PostPosted: Wed Jul 23, 2008 11:45 pm    Post subject: Reply with quote

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...
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Jul 23, 2008 11:47 pm    Post subject: Reply with quote

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.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
ninaxyz
-


Joined: 29 May 2009
Posts: 1

PostPosted: Wed Jun 03, 2009 8:25 am    Post subject: Reply with quote

How can I prevent multiple back-ups getting created to every text or picture file? I have XP operative and Office Software. Back-ups of a picture file I create keep getting generated as I try to delete them. Please advise how to stop this unnecessary multiplication.
_________________
i need help
Back to top View user's profile Send private message
aprelium-support
-


Joined: 20 Feb 2009
Posts: 356

PostPosted: Wed Jun 03, 2009 9:33 am    Post subject: Reply with quote

Ch1ck3n^ wrote:

MySQL wrote:

Not Found
Driver 3.51 Not Found

What is the problem?


The error message is pretty much self explanatory: there is obviously a problem with your MySQL setup. We strongly suggest that you use the latest MySQL installer that takes care of the driver setup and its associated programs. The latest MySQL series is now 5.x and 3.51 is obsolete and no more supported (even by its authors.)
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Visit poster's website
DonQuichote
-


Joined: 24 Dec 2006
Posts: 68
Location: The Netherlands

PostPosted: Wed Jun 03, 2009 6:10 pm    Post subject: MySQL for Windows bug Reply with quote

As you are installing MySQL for Windows, you'd want to fix the configuration bug on windows. By default, MySQL cripples all table names to lower case. This is the worst thing to do as a "work-around" to case sensitivity on Linux. The correct way to handle table names is case INsensitive, but keep the case as it is. To make MySQL get the tables right, add the following line to my.ini:

Code:
[mysqld]
lower_case_table_names=2


Do so before you create any table, so directly after runing the installer.
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Tutorials All times are GMT + 1 Hour
Goto page Previous  1, 2, 3
Page 3 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group