050611 01:25:37 mysqld started 050611 1:25:37 Can't start server: Bind on TCP/IP port: Address already in use050611 1:25:37 Do you already have another mysqld server running on port: 3306 ? 050611 1:25:37 Aborting
Damn process was running in the background. Im sure I checked ps aux. Im offically captain oblivious. On 6/10/05, John Tate <[EMAIL PROTECTED]> wrote: > I just tried everything here, however it has come to the same problem > again... mysql refuses to start... > > -bash-3.00# mysqld_safe > Starting mysqld daemon with databases from /var/mysql > 050610 21:24:10 mysqld ended > > > On 6/10/05, Matthew S Elmore <[EMAIL PROTECTED]> wrote: > > John, > > > > Do not want you to get frustrated! > :) Happy Face! > > Its alright I have managed to sleep now. > > > > Here are all the changes I made on my local machine (OpenBSD > > 3.7/sparc64, but config is the exact same on my OpenBSD 3.7/i386 machines). > > > > I normally set everything up before installing mysql. Unless you have > > databases to save I would recommend starting from scratch. > > > > # pkg_del mysql-server-4.0.23p1 > > # rm -rf /var/mysql > > # rm -rf /var/www/mysql > > # pkg_add mysql-server-4.0.23p1.tgz > > > > contents of /etc/my.cnf (copied from /usr/local/share/my-small.cnf) is > > at bottom of email. > > > > # mkdir /var/www/mysql > > # chown _mysql:_mysql /var/www/mysql > > > > # cat /etc/my.cnf > > # The following options will be passed to all MySQL clients > > [client] > > #password = your_password > > port = 3306 > > socket = /var/www/mysql/mysql.sock > > > > # Here follows entries for some specific programs > > > > # The MySQL server > > [mysqld] > > port = 3306 > > socket = /var/www/mysql/mysql.sock > > > > .... no other changes below this > > > > Restart apache, be sure your php4/5-mysql packages are installed > > properly and you should be good to go! It need not be very complicated! > > > > Matt > > > > > > > > Matthew S Elmore wrote: > > > For your needs, you can use mostly the default settings. > > > > > > Look in /usr/local/share/mysql > > > > > > There will be several files called my-small.cnf, my-large.cnf, etc. Copy > > > my-small.etc to /etc/my.cnf. Edit the file and change the two lines > > > where it references the mysql socket. > > > > > > Remove any links you made before doing this. > > > > > > Regards, > > > Matt > > > > > > > > > John Tate wrote: > > > > > >> Right, I created a hardlink of the socket into > > >> /var/www/mysql/mysql.sock and changed this directive in php.ini to the > > >> following... > > >> > > >> mysql.default_socket = /var/www/mysql/mysql.sock > > >> > > >> I however could not find the my.cnf file, where is it on OpenBSD 3.6, > > >> I did a "find / | grep my.cnf" which showed up nothing. > > >> > > >>> From phpinfo()... > > >> > > >> > > >> MySQL Support enabled > > >> Active Persistent Links 0 > > >> Active Links 0 > > >> Client API version 4.0.20 > > >> MYSQL_MODULE_TYPE external > > >> MYSQL_SOCKET /var/run/mysql/mysql.sock > > >> MYSQL_INCLUDE -I/usr/local/include/mysql > > >> MYSQL_LIBS -L/usr/local/lib -lmysqlclient > > >> > > >> Directive Local Value Master Value > > >> mysql.allow_persistent On On > > >> mysql.connect_timeout 60 60 > > >> mysql.default_host no value no value > > >> mysql.default_password no value no value > > >> mysql.default_port no value no value > > >> mysql.default_socket /var/www/mysql/mysql.sock > > >> /var/www/mysql/mysql.sock > > >> mysql.default_user no value no value > > >> mysql.max_links Unlimited Unlimited > > >> mysql.max_persistent Unlimited Unlimited > > >> mysql.trace_mode Off Off > > > > > > > -- > John "Rockstar" Tate > Mobile: 0413 348 815 (Yep, old number, but I have a new phone) > > New Personal Website: http://kintaro.noobify.com > -- John "Rockstar" Tate Mobile: 0413 348 815 (Yep, old number, but I have a new phone) New Personal Website: http://kintaro.noobify.com
