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]
