Starting server problems

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zeedan
    #1

    Starting server problems

    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_mod e:

    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:netbi os-ssn *:* LISTEN

    tcp 0 0 192.168.0.1:net bios-ssn *:* LISTEN

    tcp 0 0 *:sunrpc *:* LISTEN

    tcp 0 0 192.168.0.196:w ww-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






    Tags: None
    • zeedan
      #2
      Re: Starting server problems

      Sorry my correct email is zeedan1@comcast .net

      "zeedan" <nospam@inmybox .com> wrote in message
      news:y4WdncHuws Zl6gLcRVn-vQ@comcast.com. ..[color=blue]
      > 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_mod e:
      >
      > 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:netbi os-ssn *:* LISTEN
      >
      > tcp 0 0 192.168.0.1:net bios-ssn *:* LISTEN
      >
      > tcp 0 0 *:sunrpc *:* LISTEN
      >
      > tcp 0 0 192.168.0.196:w ww-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
      >
      >
      >
      >
      >
      >[/color]


        Comment

        • Bill Karwin
          #3
          Re: Starting server problems

          zeedan wrote:[color=blue]
          > 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[/color]

          "restart" is not a valid option to mysqld. What's happening is that
          mysqld is ignoring the restart argument, and it's simply trying to start
          another instance of the mysql daemon process. Since there's already one
          running, it conflict with the use of the port, and aborts. But the
          original instance is still running.

          Mysqld is usually started and stopped by a front-end script, which is
          often kept in /etc/init.d/mysql (or some variation on that name).

          Try: "/etc/init.d/mysql restart"

          I have to ask, though, if mysqld is already running, why do you need to
          restart it? I find I rarely need to restart mysqld, unless I've changed
          some of its config parameters. Even restarting Apache doesn't generally
          require restarting mysqld.

          Regards,
          Bill K.

            Comment

            • zeedan
              #4
              Re: Starting server problems

              Thanks for responding I must of been thinking it was similar to samba. I got
              it working though I had to enable it in the runlevel editor. In Suse mysqld
              is in /usr/sbin and the book I was reading said I had to start it before I
              could configure it.

              Thanks again,

              Dan

              "Bill Karwin" <bill@karwin.co m> wrote in message
              news:cno7i00t3m @enews1.newsguy .com...[color=blue]
              > zeedan wrote:[color=green]
              >> 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[/color]
              >
              > "restart" is not a valid option to mysqld. What's happening is that
              > mysqld is ignoring the restart argument, and it's simply trying to start
              > another instance of the mysql daemon process. Since there's already one
              > running, it conflict with the use of the port, and aborts. But the
              > original instance is still running.
              >
              > Mysqld is usually started and stopped by a front-end script, which is
              > often kept in /etc/init.d/mysql (or some variation on that name).
              >
              > Try: "/etc/init.d/mysql restart"
              >
              > I have to ask, though, if mysqld is already running, why do you need to
              > restart it? I find I rarely need to restart mysqld, unless I've changed
              > some of its config parameters. Even restarting Apache doesn't generally
              > require restarting mysqld.
              >
              > Regards,
              > Bill K.[/color]


                Comment

                Previous template Next
                Working...