jiing wrote:[color=blue]
> Now let me describe what I have done and my purpose:
>
> Originally, I want to user ports to install phpBB
> But I found that phpBB doesn't support mysql 5.x (but the ports
> installed mySQL 5.0.0 alpha)
> so I deinstall mysql5-server and mysql5-client
> And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by
> ports
> but now , mysql is not workable
>
> freebsd# mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
> freebsd# su
> freebsd# su jiing
> freebsd [/]-jiing->mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
> all of them have problems
>
> I also try to execute
> freebsd# /usr/local/libexec/mysqld
> 050308 11:42:29 [ERROR] Can't start server: Bind on TCP/IP port:
> Address already in use
> 050308 11:42:29 [ERROR] Do you already have another mysqld server
> running on port: 3306 ?
> 050308 11:42:29 [ERROR] Aborting
> 050308 11:42:29 [NOTE] /usr/local/libexec/mysqld: Shutdown complete
>
> It say that I have another one mysql deamon and also using port 3306
> So I use
>
> mysqladmin -u root shutdown
>
> try to shutdown mysql
> The result is
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!
>
> I also execute
>
> freebsd# killall mysqld
>
> to kill all mysqld
>
> freebsd# ps xa | grep mysqld
>
> Then execute mysqld again
>
> freebsd [/]-jiing->/usr/local/libexec/mysqld
> 050308 12:58:52 [WARNING] Can't create test file
> /var/db/mysql/freebsd.lower-test
> /usr/local/libexec/mysqld: Can't change dir to '/var/db/mysql/'
> (Errcode: 13)
> 050308 12:58:52 [ERROR] Aborting
> 050308 12:58:52 [NOTE] /usr/local/libexec/mysqld: Shutdown complete
>
> I havd read
http://groups.google.com.tw/groups?h...m%3Dmailing.da
> abase.mysql.38D65AC0.400980FF%2540americasm01.nt.c om%26rnum%3D7
>
> But still not very sure of what they say
> I edit a my.cnf
> freebsd# ee /etc/my.cnf
>
> the content of my.cnf is
> [mysqld]
> socket =/tmp/mysql.sock
>
> [client]
> socket=/tmp/mysql.sock
> user=root
> host=localhost
> password=feng[/color]
Be aware the next time to never post you passwords in newsgroups!
[color=blue]
> ================================================== ============
> But when I execute /usr/local/libexec/mysqld
>
> freebsd [/usr/local/bin]-jiing->/usr/local/libexec/mysqld
> 050308 14:04:25 [WARNING] Can't create test file
> /var/db/mysql/freebsd.lower-test
> /usr/local/libexec/mysqld: Can't change dir to '/var/db/mysql/'
> (Errcode: 13)
> 050308 14:04:25 [ERROR] Aborting
>
> 050308 14:04:25 [NOTE] /usr/local/libexec/mysqld: Shutdown complete
> ================================================== ===========
> still can't work.
>
> How can I do to solve this problem, thanks.
>
> -jiing-[/color]
