Hi Christoph, @ 10:15:03 AM on 11/21/01, Christoph Starkmann wrote:
> connected to databases I try posting it here... > I tried to install mySQL under SuSE 7.1, but when trying to start the dbs, > the only thing I get is an error that > "no connection can be established to > mysql.sock at port 111 ?!?!?! > I tried to reinstall it with yast2, reinstall it manually, but to no extend. Try sticking this in /etc/my.cnf [client] port = 3306 # standard socket location socket = /tmp/mysql.sock [safe_mysqld] socket=/tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking [mysqladmin] port = 3306 socket = /tmp/mysql.sock If that doesn't get it started and you feel like reinstalling MySQL, the following should work on SuSE (give or take an error or two that should be easy to figure out if the crop up). Be sure to clean up from your previous installs, first, though. (I *think* these instructions should work) Install newest RPMS from http://www.mysql.com : $ rpm -i \ MySQL-VERSION.i386.rpm \ MySQL-client-VERSION.i386.rpm \ MySQL-devel-VERSION.i386.rpm \ Stop mysql server if it's started automatically/running: $ /etc/rc.d/mysql stop (It's a good idea to backup /etc/rc.d/mysql because upgrading the RPM later will overwrite it) Create symlinks in /etc/rc.d/rcX.d for /etc/rc.d/mysql where X is your runlevel. Up the file descriptors for (SuSE?) Linux in /etc/rc.d/boot.local (http://www.mysql.com/doc/L/i/Linux.html) : echo 65536 > /proc/sys/fs/file-max Add to /etc/my.cnf (create it if it doesn't exist): [client] port = 3306 # standard socket location socket = /tmp/mysql.sock [safe_mysqld] socket=/tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking [mysqladmin] port = 3306 socket = /tmp/mysql.sock *Possibly* add this to the safe_mysqld script if performance is slow later: renice -20 $$ Move database directory if necessary: $ mv /var/lib/mysql /var Start mysql server: /etc/rc.d/mysql start Change root password: mysqladmin -u root password 'new-password-here' Test mysqladmin: mysqladmin -u root -pThePassword extended-status -- -Brian Clark | PGP is spoken here: 0xE4D0C7C8 Please, DO NOT carbon copy me on list replies. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]