Hi, I appologise if I'm not posting this to the correct group, but I'm
having problems starting MySQL server. I need it in order to post a
websurvey for a research project I'm doing for a college computer ethics
class.
Well here is the output several commands, from netstat -a I can see that
MySQL is listening, but when I try to start the server I get a port error.
I'm running SUSE 9.1 and I searched all over the web for info on this error,
but nothing I found worked. I've been using Linux for a while now, but I'm a
newbie when it comes to MySQL. Any help would be greatly appreciated. Here's
the output and the error at the end.
zeedan@linux:~> su root
Password:
linux:/home/zeedan # cd /
linux:/ # mysqladmin -u root -p version proc
Enter password:
mysqladmin Ver 8.40 Distrib 4.0.18, for suse-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.18-Max
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 11 hours 10 min 51 sec
Threads: 1 Questions: 25 Slow queries: 0 Opens: 12 Flush tables: 1 Open
tables: 6 Queries per second avg: 0.001
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 11 | root | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+
linux:/ # msql -u root -p mysql
bash: msql: command not found
linux:/ # mysql -u root -p mysql
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.0.18-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)
Connection id: 12
Current database: mysql
Current user: root@localhost
SSL: Not in use
Current pager: less
Using outfile: ''
Server version: 4.0.18-Max
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 11 hours 12 min 29 sec
Threads: 1 Questions: 29 Slow queries: 0 Opens: 12 Flush tables: 1 Open
tables: 6 Queries per second avg: 0.001
Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000
--------------
linux:/ # netstat -a
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 *:blackjack *:* LISTEN
tcp 0 0 *:nfs *:* LISTEN
tcp 0 0 *:838 *:* LISTEN
tcp 0 0 *:mysql *:* LISTEN
tcp 0 0 localhost:netbios-ssn *:* LISTEN
tcp 0 0 192.168.0.1:netbios-ssn *:* LISTEN
tcp 0 0 *:sunrpc *:* LISTEN
tcp 0 0 192.168.0.196:www-http *:* LISTEN
tcp 0 0 *:ipp *:* LISTEN
linux:/ # /usr/sbin/mysqld restart
041120 13:01:20 Can't start server: Bind on TCP/IP port: Address already in
use
041120 13:01:20 Do you already have another mysqld server running on port:
3306 ?
041120 13:01:20 Aborting
041120 13:01:20 /usr/sbin/mysqld: Shutdown Complete