MySQL

[Robert L Cochran]

I'm running the x86_64/glibc 2.3 version of MySQL 4.1.7. My personal 
machine is an AMD Athlon 64 system so I want the x86_64 versions of 
MySQL. Here is what I have installed:

[rlc at bobcp4 ~]$ rpm -qa | egrep MySQL
MySQL-devel-4.1.7-0.glibc23
MySQL-client-4.1.7-0.glibc23
MySQL-server-4.1.7-0.glibc23
MySQL-shared-4.1.7-0.glibc23

I installed these with no errors as follows (and I use the same 
procedure for 32 bit, x86 installs):

1. When installing Fedora Core, do not install any databases or php. 
Just installing the web server (httpd) is sufficient. You do not want to 
install anything that might be dependent on the Fedora version of mysql.
2. Download MySQL from the MySQL website. You need the server and client 
packages at a minimum. You may also need the devel and shared packages.
3. Install the MySQL-client-* package first.
4. Install the MySQL-server-* package last. Follow the directions for 
changing the root user's password.

You should now have a clean MySQL install that runs just fine. You can 
start adding users and specifying privileges, then creating databases.

Am I a MySQL expert? No. Some day I hope to become one. You can search 
the archives on the mysql-list mailing list. Others have had this and 
much more complex problems. Join the list at mysql.com.

Another very good thing to do is to buy the MySQL books written by Paul 
DuBois. His book "MySQL, Second Edition" is extremely comprehensive and 
will get you up and running quickly.

Bob



Andrew Choens wrote:

>Any mysql nuts out there?
>
>I have a laptop with FC3 freshly installed on it.  I am trying to get
>mysql to work on the laptop.  I chose FC3 for the laptop even though I
>knew it did not use the latest release from mysql.  I installed Fedora,
>but NOT mysql from the CDs.  I then went to the mysql homepage and
>downloaded the newest 4.1 release.  I grabbed the server, the
>libs/headers, the shared-compat and the client binaries.  I even
>downloaded MyODBC.  I installed everything with rpm. RPM returned no
>errors.  I made sure the daemon was running, and then used the
>mysql_install_db command as root as I was instructed to do by rpm.  Then
>I went on and installed the new mysql administrator and query tools.
>I'll admit, they are half the reason I want mysql on this computer.  
>
>Unfortunately, right now, whenever I try to use those tools, or the
>command line client, mysql, I get a socket error.  When I boot up mysql
>gives a greenlight and seems to be up and running according to my logs,
>but I can't get it to actually give me a response.  The error I get is
>this.
>
>/usr/bin/mysqladmin: connect to server at 'localhost' failed
>error: 'Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (2)'
>Check that mysqld is running and that the socket:
>'/var/lib/mysql/mysql.sock' exists!
>
>
>the file /var/lib/mysql/mysql.sock does NOT exist.  I've never had this
>problem before, and can't find anything in the documentation to fix it.
>In the course of playing with different versions, sometimes I'll get the
>same error, only the number (2) is replaced by (11).
>
>I've tried downgrading to the default 3.23 (or whatever the exact # is)
>and I'm getting the same error.  I would like to use the newer version,
>but I would REALLY like to be able to connect to the database here on my
>localhost.  I've installed mysql 4.x on other computers, using the
>binaries from mysql and I've never had this problem on SUSE or FC2.  If
>anyone has any ideas, I sure would like to hear them.  I'm NOT a real
>systems admin, I just pretend to be one at work (I'm the closest we
>have).  
>
>I want to use this laptop as a development platform for a simple
>database to keep client info on.  I work from my home quite a bit, so I
>made my development platform a laptop.  I can't connect to mysql locally
>or over the network at home or on the network at work.  Everything else
>on the computer is running great.
>
>Thanks
>andy
>
>  
>