Instalacja Mysql 5.0

[TMick]

Pobieram wszystkie paczki z :

 

Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads

http://dev.mysql.com/downloads/mysql/5.0.html#downloads

 

Wydaje polecenie

rpm -Uvh *.rpm

 

Instalator przechodzi gładko, jednak przy próbie połączenia z serwerem wyświetla :

 

connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql    .sock' (2)'

 

Dlaczego nie instaluje się katalog /var/lib/mysql/* ?

[Amos]

Katalog /var/lib/mysql na pewno jest, tylko przed połączeniem się z serwerem trzeba by go najpierw uruchomić:

mysqld start

 

A najlepiej było zainstalować MySQL poleceniem:

yum install mysql*

[TMick]

Katalog /var/lib/mysql na pewno jest, tylko przed polaczeniem sie z serwerem trzeba by go najpierw uruchomic:

mysqld start

 

Uruchamiam mysqld

 

[Warning] Asked for 196608 thread stack, but got 126976
061028 12:37:53 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

061028 12:37:53 [ERROR] Aborting

061028 12:37:53 [Note] mysqld: Shutdown complete

A najlepiej bylo zainstalowac MySQL poleceniem:

yum install mysql*

 

Po odpaleniu Yuma

 

Gathering header information file(s) from server(s)
Server: Fedora Core 2 - i386 - Base
Server: Fedora Core 2 - i386 - Released Updates
Finding updated packages
Downloading needed headers
Resolving dependencies
...Dependencies resolved
I will do the following:
[install: mysql-devel 3.23.58-16.FC2.1.i386]
[install: mysql-bench 3.23.58-16.FC2.1.i386]
[install: mysql-jdbc-tomcat 3.0.8-2.noarch]
[install: mysql-server 3.23.58-16.FC2.1.i386]
[install: mysql 3.23.58-16.FC2.1.i386]
[install: mysql-jdbc 3.0.8-2.noarch]
I will install/upgrade these to satisfy the dependencies:
[deps: commons-dbcp 1.1-3.i386]
[deps: commons-fileupload 1.0-8.i386]
[deps: tomcat 4.1.27-13.i386]
[deps: libstdc++34 3.4.0-1.i386]
[deps: tomcat-libs 4.1.27-13.i386]
[deps: servletapi 1:2.3-4.i386]
[deps: commons-pool 1.1-3.i386]
Is this ok [y/N]: y
Downloading Packages
Getting commons-dbcp-1.1-3.i386.rpm
commons-dbcp-1.1-3.i386.r 100% |=========================| 205 kB    00:02
Getting commons-fileupload-1.0-8.i386.rpm
commons-fileupload-1.0-8. 100% |=========================|  43 kB    00:00
Getting mysql-devel-3.23.58-16.FC2.1.i386.rpm
mysql-devel-3.23.58-16.FC 100% |=========================| 577 kB    00:03
Getting tomcat-4.1.27-13.i386.rpm
tomcat-4.1.27-13.i386.rpm 100% |=========================| 1.2 MB    00:07
Getting libstdc++34-3.4.0-1.i386.rpm
libstdc++34-3.4.0-1.i386. 100% |=========================| 263 kB    00:01
Getting mysql-bench-3.23.58-16.FC2.1.i386.rpm
mysql-bench-3.23.58-16.FC 100% |=========================| 538 kB    00:03
Getting tomcat-libs-4.1.27-13.i386.rpm
tomcat-libs-4.1.27-13.i38 100% |=========================| 2.8 MB    00:15
Getting mysql-jdbc-tomcat-3.0.8-2.noarch.rpm
mysql-jdbc-tomcat-3.0.8-2 100% |=========================| 2.5 kB    00:00
Getting mysql-server-3.23.58-16.FC2.1.i386.rpm
mysql-server-3.23.58-16.F 100% |=========================| 1.3 MB    00:07
Getting mysql-3.23.58-16.FC2.1.i386.rpm
mysql-3.23.58-16.FC2.1.i3 100% |=========================| 3.2 MB    00:18
Getting servletapi-2.3-4.i386.rpm
servletapi-2.3-4.i386.rpm 100% |=========================| 146 kB    00:00
Getting mysql-jdbc-3.0.8-2.noarch.rpm
mysql-jdbc-3.0.8-2.noarch 100% |=========================| 210 kB    00:01
Getting commons-pool-1.1-3.i386.rpm
commons-pool-1.1-3.i386.r 100% |=========================|  73 kB    00:00
Running test transaction:
Test transaction complete, Success!
servletapi 100 % done 1/16
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
mysql 100 % done 2/16
commons-fileupload 100 % done 3/16
commons-pool 100 % done 4/16
commons-dbcp 100 % done 5/16
tomcat-libs 100 % done 6/16
mysql-jdbc 100 % done 7/16
libstdc++34 100 % done 8/16
tomcat 100 % done 9/16
mysql-devel 100 % done 10/16
mysql-bench 100 % done 11/16
mysql-jdbc-tomcat 100 % done 12/16
mysql-server 100 % done 13/16
Erasing: MySQL-devel 14/16
Erasing: MySQL-server 15/16
Erasing: MySQL-client 16/16
Installed:  mysql-devel 3.23.58-16.FC2.1.i386 mysql-bench 3.23.58-16.FC2.1.i386 mysql-jdbc-tomcat 3.0.8-2.noarch mysql-server 3.23.58-16.FC2.1.i386 mysql 3.23.58-16.FC2.1.i386 mysql-jdbc 3.0.8-2.noarch
Dep Installed:  commons-dbcp 1.1-3.i386 commons-fileupload 1.0-8.i386 tomcat 4.1.27-13.i386 libstdc++34 3.4.0-1.i386 tomcat-libs 4.1.27-13.i386 servletapi 1:2.3-4.i386 commons-pool 1.1-3.i386
Transaction(s) Complete

 

Jak widac na listingu pobralo jakies stare paczki...

 

Odpalam mysqld

-bash: mysqld: command not found

 

Odpalam mysql

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[gajownik]

Server: Fedora Core 2 - i386 - Base

Nie żebym się czepiał, ale ta wersja jest tak stara i dziurawa, że lepiej jej ze względów bezpieczeństwa nie używać. Zastanów się lepiej nad instalacją nowszej wersji systemu (FC2 to brak wsparcia, brak nowym pakietów, itd.)

[TMick]

Niestety serwerownia w której mam wykupiony serwer nie oferuje innych wersji systemu Fedora.

 

Pozostaje mi pobawic sie na obecnej lub wymienic dystrybucje na inna...

 

Wracajac do tematu

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

 

Co moze byc przyczyna ?

 

Edit :

Wywalilem stare paczki Yuma

Przekompilowalem calosc poleceniem :

rpm -Uvh *.rpm --nodeps --force

 

Serwer dziala : mysql -status

 

mysql  Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i686) using readline 5.0

Connection id:          3
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:       ;
Server version:         5.0.24a-standard
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 46 min 36 sec

Threads: 1  Questions: 3  Slow queries: 0  Opens: 11  Flush tables: 1  Open tables: 6  Queries per second avg: 0.001

 

 

Stracilem za to lacznosc z panelem Plesk.

Przy próbie polaczenia https://111.222.333.444:8443/ zwraca 403 Forbidden

Próba ponownej kompilacji panelu konczy sie fiaskiem.

Jakas idea ?