Clean install of MySQL?

linuxhavok · Post by **linuxhavok** » Tue Dec 28, 2004 5:23 pm

Hello

Ok, after two times trying to upgrading Fedora Core 3 to mysql 4.1!

What is the right way to upgrade. step by step to not have error's or broken dependenes to user rights with MySQL, SElinux and Feora?

I for the world of me can figure out why with Core 3, Red Hat / Fedora did upgrade to 4.1 yet.

Update, here is where I'm at now!

Ok, here is where I'm at again.

All of MySQL is removed and PHP, I want to install mysql 4.1 and then PHP 4.3.

What is the right way to install Mysql with Fedora Core 3 being it uses the SELinux package now. I must likely will then download the PHP rpm's from the update files site at fedora.

Please mind you step by step though I'm not a pro!

I've been reading some on the net and everyone seems to be having trouble upgrading or new install of mysql.

I'd really like to get it right, laughing on the 3nd try!

Thanks.

IH

worker201 · Post by **worker201** » Wed Dec 29, 2004 5:01 am

Get the source:
http://dev.mysql.com/get/Downloads/MySQ ... /from/pick

Read the installation manual:
http://dev.mysql.com/doc/mysql/en/Insta ... ource.html

MySQL is not that hard to install at all. And the instructions provided by MySQL are very comprehensive. Make a couple tries of it, and then get back to us if you have any specific questions, problems, or issues.

agent007 · Post by **agent007** » Thu Dec 30, 2004 9:45 am

The easiest way to install is via RPM packages..You can update them with a -u switch and delete with a -e. Installing via source code makes it pretty difficult to update or keep track of version numbers.....

linuxhavok · Post by **linuxhavok** » Fri Dec 31, 2004 9:07 am

agent007 wrote:The easiest way to install is via RPM packages..You can update them with a -u switch and delete with a -e. Installing via source code makes it pretty difficult to update or keep track of version numbers.....

Hello

Here is where I'm at, I installed MySQL-shared-compat-4.1.8-0, that the url was given to first then the server and then the rest. when trying to log into mysql I still get this error? Been reading on mysql site and still same error?

[root@locahost ~]# rpm -qa | grep -i mysql
MySQL-server-4.1.8-0
MySQL-devel-4.1.8-0
MySQL-shared-compat-4.1.8-0
MySQL-client-4.1.8-0
MySQL-bench-4.1.8-0
MySQL-shared-4.1.8-0
MySQL-Max-4.1.8-0
[root@locahost ~]# mysql -root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any help, thanks

agent007 · Post by **agent007** » Sat Jan 01, 2005 11:56 am

Issue the command:
mysql -u root

If that doesnt work, delete the database and restart mysqld or reboot....

Void Main · Post by **Void Main** » Sat Jan 01, 2005 12:33 pm

linuxhavok wrote:[root@locahost ~]# mysql -root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

That looks identical to the message I get if I try and execute the mysql client when the database server is not running:

Code: Select all

# /sbin/service mysqld stop
Stopping MySQL:                                            [  OK  ]
$ mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Is your mysql server service running?

# /sbin/service mysqld status

If not start it:

# /sbin/service mysqld start

and set it to start on boot:

# /sbin/chkconfig mysqld on

If it's not starting then you'll have to figure out why, usually the system logs are a good place to start.

P.S. I am not sure why Fedora/Red Hat drags their feet on the later MySQL versions, there is usually reasons for it. For me, the included version works just fine for everything I do. You may require the extra functionality of the 4.x though...