Using MySQL

[smercer]

Hi all,

I would have posted In a database forum if they had one but they are not going to have one here (http://www.webdeveloper.com/forum/showthread.php?s=&threadid=50896).

I am having a problem using MySQL, I am very new to this and am having a problem geting it to work, all I have done is installed MySQL server and I cant open MySQL, I can't even have Microsoft Access use it for the backend database. Is it because I need the have the client version as well?
using Windows 2000

Thanks in advance!!

[pawky]

Originally posted by smercer
I would have posted In a database forum if they had one but they are not going to have one here (http://www.webdeveloper.com/forum/showthread.php?s=&threadid=50896).

This was not needed at all to say. It was also very immature.

[smercer]

Originally posted by pawky
This was not needed at all to say. It was also very immature.
if you don't have anything nice to say don't say it at all.

[MstrBob]

Originally posted by smercer
Hi all,

I would have posted In a database forum if they had one but they are not going to have one here (http://www.webdeveloper.com/forum/showthread.php?s=&threadid=50896).

I am having a problem using MySQL, I am very new to this and am having a problem geting it to work, all I have done is installed MySQL server and I cant open MySQL, I can't even have Microsoft Access use it for the backend database. Is it because I need the have the client version as well?
using Windows 2000

Thanks in advance!!

Can I have a bit more info? What MySQL version? Do you have the MySQLAdmin with it? This will appear in at the bottom right of your start bar, near the time, in the form of a traffic light, allowing you to know the current status of the server.

How do you plan on interacting with the database?

[smercer]

Originally posted by MstrBob
Can I have a bit more info?

I will be using it on the internet, and I have to set it up first before puting it on a web server (which will be in house). when the website visiter clicks on a event in a list box in a Javascript calender, the bottom half of the page will change acording to what the vister choose, this is why I need MySQL (so I was told).

Currently I am doing it all on one machine but when the db and website (we don't even have a domain name yet) is finished I will transfer it to the server.

I am also having trouble finding the client for this as well. On the MySQL website I can't find where to download the client although the website says They are Server and client, I can only find Server.

What MySQL version?
MySQL Server 4.1.7 for Windows

Do you have the MySQLAdmin with it? This will appear in at the bottom right of your start bar, near the time, in the form of a traffic light, allowing you to know the current status of the server.
No I don't have the MySQLAdmin with it. There is however a MySQL service in the Windows 2000 services. I was not sure of what to download and what not to download.

How do you plan on interacting with the database?

with the internet as stated above, but I want to have Access 2000 (or later) as the front end so that it is easier to change the data in the data base.

I hope I have given all the info you need.

Thanks so much for helping!!!

[ray326]

One thing a lot of MySQL newbies fail to actually run the database server. Is your server running? The tool MstrBob refers to is in the dir with the MySQL executables. That's how I've always run it myself.

[smercer]

Originally posted by ray326
One thing a lot of MySQL newbies fail to actually run the database server. Is your server running? The tool MstrBob refers to is in the dir with the MySQL executables. That's how I've always run it myself.

It is the server version on the machine I am doing the website on. It also is on set to automatic in the services.

I will edit what i have put to save confusion. Thanks for asking and helping.

[smercer]

Originally posted by ray326
The tool MstrBob refers to is in the dir with the MySQL executables. That's how I've always run it myself.

Ok I have found this file. I have executed this file and a heap of dos stuff flashed by I couldn't see what happened.
also nothing changed near the in the system tray
Now what do I do?

Thanks for helping

[smercer]

Thanks guys! I can double click on the icon and it comes up, alright, weird because all the tutorials say it can only be opened from the command prompt.


Thanks again!!

[Stephen Philbin]

I don't get it. I though MSaccess was a database only deal that didn't have a server? I though it just threw out astonishingly large amounts of pointless data and let the user sift through it all to find what they wanted? If so, how on earth would you have a databse act on a database? Surely you'd want a server acting on the database? (Like the MySQL server acting on the MSaccess database. An absurd notion as far as I can see, but the only arrangement I can imagine that would even vaguely make sense to me.)

If you want some part of MySQL to do something though, there's a pretty good chance you'll find what you need in the manual. I don't know how it comes on windows (I'm guessing in a similair or same way), but when I download MySQL you get the manual as a bunch of html pages you can just view like you would a normal web site. It's just stored locally along with the source. Just have a look in there and you'll probably find a contents page for the manual. Just look on there for what you want and get reading. ;) There's lots of other great info in there too which you will inevitabloy find very useful. :D

I can't really be much use to you. But the manual certainly should be. ;)

[russell]

Mr Herer
I don't get it. I though MSaccess was a database only deal that didn't have a server? I though it just threw out astonishingly large amounts of pointless data and let the user sift through it all to find what they wanted? If so, how on earth would you have a databse act on a database?
MS Access is a database, but it has a built-in GUI. It isn't what you'd call an Enterprise RDBMS by any stretch of the imagination. It is primarily a database for desktop use, though it can be used as the backend for a lightweight web site, or for desktop applications.

Some people use the built-in GUI to access other DBs, as it has built-in features for Pass-Through querries, and (don't do this in a multi-user environment) it allows you to link to external data sources, operating on the remote data directly.

Oh, and it does have an SQL parser, so that you can execute real SQL commands, so it isn't as pointless as you thought, but it sure isn't Oracle, DB2, or MS SQL!

[Stephen Philbin]

Ahhhhhhhhhhhhhhhhhhhh. Nice one for clearing that up. ;) I was becoming befuzzled. :D

[ray326]

Actually MS Access is a GUI query and report builder that is bundled with an ISAM file system database manager (not a database server) called Jet. As long as you have an ODBC driver for a database, Access can use it. (This bundling of Access/Jet was one of the drivers for the Sybase/Powerbuilder merger.)

[Stephen Philbin]

ISAM?! This just get more and more confuzzling. I always thought the only thing that went in favour of MSAccess was that it was relational?

[ray326]

Access isn't anything; it's a query tool. Jet is a file system based data store, accessible only to applications that can mount the file system on which the database file (*.mdb) resides. That's a radically differenct concept from a database server like DB2, SQL Server or MySQL. The concept of "relational" is a level above how and where the data is actually stored.