# mysql 4.1.x ??
tar -xzvf mysql-4.1.*.tar.gz
./configure --prefix=/usr/local/mysql --with-static --enable-static --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/tmp/mysql.sock --with-charset=euckr
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
These are the steps I've taken trying to install mysql on my vps server without success, tried installing 4 times now, no dice. What am I doing wrong? The /etc/my.cnf is either " /usr/local/mysql/share/mysql/my-huge.cnf" this one or my default one I tried too,
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
tried changing it all up and making it as close as I could guess for my install directory of /usr/local/mysql but all without success, been trying all day withouth any progress.
any help is very much appreciated!!!
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)
I've googled the error and tried many things, nothing is helping, lol.......
if it fails to start, try looking into the log file /var/log/mysqld.log
Rails 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
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 ::