[rlc@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
