Results 1 to 4 of 4
-
10-07-2006, 07:45 PM #1Junior Guru Wannabe
- Join Date
- Jan 2006
- Posts
- 62
Cannot install mysql 4.1.21 succesfully
# mysql 4.1.x ??
cd /usr/local/src
wget http://dev.mysql.com/get/Downloads/M...rs.hoobly.com/
tar -xzvf mysql-4.1.*.tar.gz
cd mysql-4.1.*
make uninstall
make distclean
rm config.cache
make clean
./configure --prefix=/usr/local/mysql --with-static --enable-static --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/tmp/mysql.sock --with-charset=euckr
make
make install
/usr/local/mysql/bin/mysql_install_db
groupadd mysql
useradd -M -c MySQL_Server -d /usr/local/mysql -g mysql -s /bin/nologin mysql
useradd -g mysql mysql
chown root.mysql -R /usr/local/mysql
chown mysql.mysql -R /usr/local/mysql/data
cp /etc/my.cnf /etc/my.cnf.original.bak
cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf
echo "/usr/local/mysql/bin/mysqld_safe &" >> /etc/rc.local
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
any help is very much appreciated!!!
EDIT:
Sorry I forgot to post the error I keep getting when trying to connect to mysql.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)Last edited by n00ber; 10-07-2006 at 07:48 PM.
-
10-07-2006, 11:09 PM #2Web Hosting Guru
- Join Date
- Nov 2004
- Location
- HK
- Posts
- 310
is your mysql daemon started?
service mysqld restart
if it fails to start, try looking into the log file /var/log/mysqld.logRails in DA - Ruby on Rails plugin for Directdmin | DA-Tomcat - Tomcat Manager plugin for Directdmin
DA-PgSQL - PostgreSQL plugin for Directdmin | IP Deny Manager - IP Deny Manager plugin for Directdmin
DeeperAdmin - Manager your DirectAdmin server "deeper"
Order now at http://www.daplugin.com
-
10-08-2006, 12:30 AM #3Web Hosting Master
- Join Date
- May 2006
- Posts
- 560
Run: /etc/init.d/mysqld start
If that doesn't work, check your logs and post back here!
-
10-08-2006, 12:56 AM #4Retired Moderator
- Join Date
- Jul 2001
- Location
- Singapore
- Posts
- 1,889
From your post, you install mysql from source and it is in /usr/local... thus your datadir shouldn't be in /var/lib/mysql I guess... Please find out which is your correct mysql datadir or simply remove the /etc/my.cnf and start mysql to see whether is mysql able to get started?
Giam Teck Choon
:: Join choon.net Community today to share your tips and tricks on server issues please ::
:: Singapore Dedicated Servers :: Singapore Virtual Private Servers :: Linux/FreeBSD Server Management ::