MYSQL :: JOIN Issue On WIndows Install But Not Linux Install

64-bit MySQL 4.1.14 Install: GNU/Linux Ver 2.6.9-11.ELsmp
We have attempted to install 64-bit MySQL 4.1.14 on GNU/Linux ver 2.6.9-11.ELsmp. Following are the packages that we installed this time:

MySQL-server-4.1.14-0.glibc23
MySQL-debuginfo-4.1.14-0.glibc23
MySQL-client-4.1.14-0.glibc23
MySQL-devel-4.1.14-0.glibc23
MySQL-shared-4.1.14-0.glibc23
MySQL-Max-4.1.14-0.glibc23

Our other three installs (from many months ago) of 32-bit MySQL on Linux went without hitches. This time, however, we are encountering the following error messages (following other unsuccessful attempts to connect on the installed software):Quote (MySQL error log):

Code:

Root Password Issue At Install
Having a problem setting up a password for MySQL

The reported problem when attempting to set up a root password is;

C:mysqlin>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

When checking this:

C:mysqlin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed

Root Password Issue At Install
Having a problem setting up a password for MySQL
The reported problem when attempting to set up a root password is;

C:mysqlin>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

When checking this:

C:mysqlin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port
3306: C
onnect failed

Install On Windows XP
I cant get mysql to run on my winXP computer. I have downloaded it and
installed , unzipped and run setup.exe and placed it in c:mysql.
I type the command to start the mysql server
c:mysqli mysqld --console

It opens the console and then the console shows some inoDB commands and the
console hangs.

I followed the mysql manual and i cant find the answer
there is no command prompt and nothing...how do I run mysql?

Install My SQL In Windows XP?
Can we install MY SQL in Windows XP? I tried to install but it gave error "This enterprise server sersion is not supported by this OS. Only Client version will be installed".

Install MySQL 4.1 On Windows
I'm trying to install the 4.1 alpha binary version on Windows.

After unzipping the download I don't find a setup.exe file.

MySQL 5.0.45 Windows Install
I am having an issue installing MySQL 5.0.45 on Windows 2003 (VMware). Basically, I extracted the contents of "mysql-5.0.45-win32.zip" to c: emp and double-clicked the setup.exe. However, the install wizard doesn't launch. I get a window with the install options via CLI.

Cannot Start New Install Of MySQL On RedHat Enterprise Linux
I've recently installed MySQL and PHP using YUM on a RedHat Enterprise Linux (RHEL 3) box. The output from rpm -ql | grep -i mysql shows the following are installed: Code:

How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system?

I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator.

Basically, I got caught up in a loop of incompatable modules:

# rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm
warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
error: Failed dependencies:
perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1
MySQL conflicts with mysql-3.23.58-16.RHEL3.1
Suggested resolutions:
/var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm

If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm.

I will gladly read the "manual" or docs, and would love a pointer to them.

Need To Install MyODBC 3.51.14 On Windows Client
We have recently upgraded the MySQL client on a Windows machine to 5.0.38. In concert with that upgrade, we must ensure that MyODBC 3.51.14 is properly installed, as well.

After executing searches on the mysql.com website, I cannot locate guidance for the following issues:

1) To what link do I navigate to download the MyODBC 3.51.14 installation files?

2) What must I do to the client machine to prepare it for the 3.51.14 installation? (e.g. uninstall the old MyODBC driver?)

3) What specific steps do I follow to successfully install MyODBC 3.51.14 on the client machine?

Sharing MySQL Install Between Multiboot Machines (windows)
On Windows, I multiboot W2k, WXP. All 2 have MySQL install but in different
directories and partitions. I (unfortunately) also have 2 instances of one database.

Is there a way for MySQL to share a common installation and database?

I suppose it is possible. If so, and if I install MySQL in W2K first, what are the steps to
import the database install into XP?
Will I need to install in XP again, and just import the databases? Or just create a
windows shortcut to database directory so it's automaticaly imported into XP MySQL?

First Time Install On Windows - Admin User&password Problem
I have a problem with logging in to MySQL. Access denied.

I think the issue is with the host, user and password settings. I assumed you had to add this information to the my.ini before you started the service for the first time. Is this only for WinMySQLAdmin? Is there a default?

I have tried all the solutions I could find but they seem to all require user privileges in the first place.

I simply need to have one main admin user and password and to refresh their values to be certain of the new settings in case there was one before.

Install / Re-Install MySQL 4.x
1. If I want to simply run MySQL on my RedHat Linux server (Intel) based which product to I install?

2. I have paritally installed MySQL once. Had some problems. Now that I am trying to Re-Install, it says that I cannot because previous components exists. How do I uninstall MySQL?

New WiX 4.1.5 Install
I have the MySQL Press Tutorial book and have a few questions about the new install of 4.1.5 How can I change the server to 'mysql-max' also this install seems to be missing a few folders 'scripts' etc...

Also when I try the MySQL 4.1.5 no-install the missing folders are there but I am having a few problems installing the no-install version.

I had an older version 4.0.21 installed so I stopped mysqladmin, removed the service

and followed the instructions in the book

mysqld-max --standalone

at this point the command prompt just blinks and I get no other messages on screen, PC sound as if it is working but nothing else appears on screen. So I figure lets install the service...

mysqld-max --install

And yes service installs OK but I am not able to start it...

NET start MySQL

Have restarted PC, but still same error

1067

Does some one know what the problem could be.

Also in the new 4.1.5 installed where is the my.ini file kept or my.cnf ???? as I was not able to find it.

4.1.5 does run ok but was not installed the way I wanted.

New Install
New install on Windows, MySQL version 4.00.x, i got through a few obstacles, but I'm stuck on this error:

"041012 0:16:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist"

Where do I go from here?

Install 3.23 On Mac OS X
The manual gives instructions for 4.x, but I want to use my Mac as a testing environment running the same version as my server, which is running 3.23.53.

I'm running OS X 10.3.8 on an eMac, which is still pretty close to the factory install. I'm currently using MySQL with PHP on the server, but I just don't know how to get it running on my Mac. I'm a newbie to Unix, so I don't even know how to get the "shell>" prompt on the Terminal, which is where most instructions begin.

New Install
I installed mySQL4 on a W2K machine and I'm able to connect from the c:mysqlin command line, I type mysqlshow and see test as the only database. I was reading the documentation online here and it showed a table mysql. Is that a system table that is required? Did something go wrong in my installation or is this ok?

Install
I have mysql installed and have two problems/questions:

1. When I go to start up mysql I receive the following: error 2002 (hy000): can't connect to local mysql server through socket 'tmp/mysql.sock' I have been searching the net for help but haven't found the answer.
2. I want to have mysql start on start up - do I have place a command in /etc/rc.local? If so what?
3. Simiarl to #2, but when I want to start mysql, I have to go to the directy /usr/local/mysql/bin and start mysql that way. I know there is a way to just make it so you can type the mysql command anywhere and logged into mysql

New To Mysql Install
i installed mysql and its a weird program, "WinMySQLAdmin 1.4".

Anyways I got phpMyAdmin also, and I guess I just drop it any of my
virtual host folders and it works with the MySQL software.

I get some security warnings, Im not too concerned because this is for practice.

If i make a new DB in phpMyAdmin it doesn't show up in WinMySQL Admin software. The only one that shows up is the one called "test" that I made in command prompt. This seems kind of confusing, but is there a way I can just make this phpMyAdmin work with WinMySQL Server?

I dont know if its a REAL database if its just appearing in phpMyAdmin, this stuff is really confusing to install, I just want to make databases and work it with php, not become an installation expert

Download And Install OSX
I have downloaded the mysql-standard-5.0.24a-osx10.4 .tar archive from the MACOSX section of the download page and expanded the archive using Stuffit Expander 10.0.2. From what I understand I am supposed to end up with .dmg disc image file from which to install Mysql 5. However the archive expands into a number of folders with no .dmg file.

Cannot 'USE Mysql' In New 5.0.45 Install On Mac
After a new install on a Mac, I cannot USE the mysql database. Even though I cannot USE it, I can select from it.

Sean
====================================

$ mysql --user=root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6
Server version: 5.0.45 MySQL Community Server (GPL)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)

mysql> use mysql
ERROR 1049 (42000): Unknown database 'mysql'

mysql> select User,Host from mysql.user;
+------+-------------+
| User | Host |
+------+-------------+
| root | 127.0.0.1 |
| root | 174.6.1.4 |
| root | localhost |
+------+-------------+
3 rows in set (0.00 sec)

How Do You Install Mysql?
I'm very new to this and I've been trying to figure this out for a few weeks now. Theres not many sites that tell you step by step what you need. I have a host that im trying to put phpnuke on. My understanding is that i need to install mysql, phpmyadmin, and then phpnuke. I also understand that you need to configure it. Could someone tell me how to configure the files step by step? It is a linux server.

How To Install MySQL 5.0.37
Please anyone explain step by step to me how to install MySQL 5.0.37 ? I downloded "Windows installer" and "Mysql noinstall 5.0.37".My platform is .NET 2005 with Windows XP professional.

Which one is first install? i want to my syatem act as a server and other three systems as client.

New Install Of MySQL 4.x
Hopefully there is an easy solution to this. I have an older version that seems to work with the same settings. I have install this copy on Windows XP. I created a server
called:

Name:  DEVSQL
Host Name: localhost
User Name:  root
Password:   blank

I am using the MySQL Control Center.

It states: Connection added successfully.
But when I attempt to connect it states:
[DEVSQL] ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

I am starting a new project and I need to use this current version of MySQL.

Any suggestions would be appreciated. I have downloaded the MySQL driver and installed it.

Install & Use MySQL
I'd like to create a FORUM site for an existing web site and would like to use mySQL for the database. The existing web site currently uses MS Access DB and it's working well. HOwever, for a FORUM site, I believe I will need a more robust DB management system.

No Service In 98 How Install?
I'd really like to stay with win98. How do I set it up? I can't do the menu it grays out the install as service part.

Is There A Right Way To Install MySQL?
I want to create a web application in Dreamweaver with MySQL, PHP and/or Coldfusion. Is there a right way to install these into my Windows XP system, I mean should I install first MySQL followed by PHP and Coldfusion? Also, should I install Apache also? What about IIS? And last, it is better to run Apache with PHP or ColdFusion with PHP.

MySQL Install
I just installed MySQL on a Windows XP machine, and upon using the SHOW
DATABASES command, I was suprised to see that the only table that exists
is the 'test' table. Isn't there supposed to be a 'mysql' table there
also? Did I miss something?

Win XP Install Error
I downloaded MySQL5.0.18 Windows (x86) with installed. Installed and got error when trying to start service "Error:0". I removed MySQL and tried it again, same results. Removed it again. Downloaded MySQL5.0.18 Windows Essentials (x86) got the same results, "Error:0" service not started.

I have used Access for a number of years but have never used "MySQL" and my son wants to put some databases (6 or 7 tables) up on a server for his web site.

Install MySQL 4.0.x For PHP
I've setup MySQL on Windows several times and figured it would be relatively straightforward on Linux;)

I have RH9 Linux installed, and have successfully upgraded both Apache 2 and PHP 4 to the latest versions.

I compiled PHP with MySQL.

Okdoke, now I couldn't get MySQL 3.23.54a-11 which comes with RH9 to work - I think I was just being dense...

So I then did the following (even more dense of me!):

1) Tried to rpm -i mysql-server-4.0.18-0
// This failed complaining: "MySQL-server... conflicts with file from package mysql-3.23..." lots of times

2) Tried to rpm -i mysql-client-4.0.18.0
//get the same error as point 1 above.

3) (really dumb on my part here) I did rpm -e mysql-server-3.23.54a-11
// I thought this would clear up points 1 and 2 - d'oh!

4) (getting even dumber...) I did rpm -e mysql-3.23.54a-11
// This wouldn't go through as mod_auth_mysql and php-mysql need it as a dependency.

I am now left in the very self-inflicted state of having only half of MySQL 3.23 installed, none of 4.0, and am unsure if any MySQL is currently working with PHP 4.

Where I would like to be is with either MySQL 3.23 or MySQL 4.0 installed, running, and accessible to PHP. I will need to alter PHP to not use the built in MySQL as the make of PHP informed me that I should use an external version of MySQL if using it with non-PHP projects.

Is Version 5 Ok To Install?
I am currently using MySQL 3.23 for a live web site. I have new
queries that need UNION provided in v4.0.0+. It's a simple db with 5
tables and doesn't perform any e-commerce type transactions. All of
the 7 tables are of type MyISAM. So I have to upgrade MySQL on the
live server.

Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application
is simple - is version 5 safe? My guess is that the core of the
server engine would be much the same for simpistic queries?

What are other people experience and thoughts on this? I understand
that safest would be version 4, then 4.1, then 5 - however it would be
nice to have 4.1's ability to do subqueries and derived tables.

Mysql RPM Install On FC4
I have just installed MySql 5.0.18 on a fresh installation on RH fedora core 4 using RPMs but the service won't start. Any ideas, can I see a log of why its failing anywhere?

How To Remove SQL 3.X And Then Install SQL 4.X?
I have downloaded and installed Redhat Linux Fedora 3 which comes with MySql 3.23.58.13 pre-installed. I would like to upgrade this to the latest version of MySql. Having read the documentation section it says that i need to completely remove the old version of MySQL before i attempt to install the new version. Since I am new to linux and MySql does anyone know how i can remove it in full and then get started with an installation of the latest version?

Cannot Install MySQL
I've just downloaded the latest version of MySQL form mysql.com (4.0.21) and unzipped it then ran setup.exe. In theory that brings up the install wizard.

Mac (OSX) Can't Not Install MySQL
If i click on the link at THERE ARE DIFFERENT results:

Here is result #1

I get a message...........

"Internet Explorer does'nt know how to handle the type of file you have selected. You can choose to save this file to your disk or you can configure a helper application."

Hre is result #2

I get message............

The file "mysql 2" does not appear to be compressed or encoded. The application "StuffIt Expander.app" might be able to open this file. Would you like to try opening the file using "Stuffit Epander app"?

- I try over and over and the above message keeps poping up!

Here is result #3"

I get message............

"Couln't open the file "mysql 2" because it is not a file that QuickTime understands"

Cant Install Mysql
Every time I run the mysql instance config.exe it stops at the 3rd step and it says " can not create windows service for mysql. error 0. I have no idea what this means and why I'm getting this.

Simple Install
i want to install mysql-max version from the tar file i downloaded. i wish to use it sql node in cluster. so i followed the instructions in chap 15 mysql ref manual.
but could not find specific instructions to install sql node. and how to configure the my.cnf .

Version 5 Install
I am currently using MySQL 3.23 for a live web site. I have new
queries that need UNION provided in v4.0.0+. It's a simple db with 5
tables and doesn't perform any e-commerce type transactions. All of
the 7 tables are of type MyISAM. So I have to upgrade MySQL on the
live server.

Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application
is simple - is version 5 safe? My guess is that the core of the
server engine would be much the same for simpistic queries?

What are other people experience and thoughts on this? I understand
that safest would be version 4, then 4.1, then 5 - however it would be
nice to have 4.1's ability to do subqueries and derived tables.

Xampp Install
I installed MySQL through the Xampp install. My problem is administering the databases. I am using Ubuntu (like Debian) and installed the MySQL Administrator package that gives me a GUI admin prgram.

Problems:
1) I can't connect to the localhost database in the GUI admin program
2) I don't know what my username is.
- Xampp provides a web-based admin program that I have a user and password
for. However I can't create a database in that program. Outside of that
program it appears that my username is not a system user. Is there a way
to log into mysqladmin with that username?
3) I can't admin the server other than adding tables to the premade databases.

MySQL Install
It installs (at least it seems so) ok, but I never have "access" to the database. It always says "Access denied for user: '@localhost' to database 'mysql'

This is not on a network, but on a laptop for myself. No one but me uses it and like I said, I am only setting this up for educational purposes (not real use). I can see the two tables, test and mysql, using 'mysql show'...but cant really do much more.

I started the Admin GUI tool to look at the .ini file, and it has HOST=Jaret, my username and then my password. I tried logging on with these values but it never works.

Install MySQL 5.0
im only using a personal PC at home.. is it ok if install mySQL even w/o connection to network?

MyODBC Install
For the fourth day I'm trying to install MyODBC. I installed the old 2.5 ver as well as the newest 3.5.The install completes successfully but when I go to the ODBC admin and try to add a new DSN, mysql is not in the driver list. I checked the registry and it is there- but not in the list.

Please someone help, I've never been pushed this far back in development by something that seems so simple / are there any 3rd part MySQL drivers I can use?

Which Version To Install
I've got a book to teach myself MySql and i need the software.
when i go to the website there are so many different versions to download. Which one should i use?

Install Connector
I must connect with .NET to a MySQL-DB. But the MySQL-DB is not on my local developer PC but on a server in our Windowsnetwork. Where must I install the ODBC or .NET connector, on the local developer PC or on the DB-server ?

Re-Install MySql
I want to put a MySql database on my network file server.

Right now I have it on my local workstation and I been writing a VB .NET application to access the local data. Now I need to start testing it on the network.

Do I have to reinstall MySql to get the data files on the network computer?

MySQL/PHP Install
Forgive me if I'm being an idiot, this is my first time installing anything on Linux (RedHat 6.2).

I successfully installed MySQL (3.23.32) using the rpms (I created a test db that works fine). Now I'm trying to install PHP (4.0.4pl1), but configure gives me the following error: cannot find [mysql] header files under /usr/bin. I'm using the option --with-mysql=/usr/bin because the rpms installed everything there, instead of /usr/local/mysql, which is where I would have installed it if given an option. Poking around I found the header files in /usr/include/mysql, so I tried to specify the option --mysql-includes=/usr/include/mysql, but configure says that's an invalid option.

4.1.18 Pro Version Install
I have been working with an install of MySQL on a MacOS 10.4 server. I need to have the Pro version installed of MySQL. I have purchased a MySQL network account and am able to download and install the pro version 4.1.18. However in my MySQL Administrator when viewing information it is displayed that I am running MySQL server version 4.1.10a (is it not supposed to also state that it is the Pro version here?) and my client version is 5.0.xx. What gives that neither of these versions match 4.1.18? I have reviewed the install in the /usr/local/mysql directory and all seems correct and my symbionic link appears to point new my version 4.1.18 install.