как сделать так чтобы при включении компа поднимался mysql сервер?

[easy2002]

попробуй ещё раз

Код: [Выделить]

sudo update-rc.d -f mysql remove
sudo update-rc.d mysql defaults

[m4dn3ss]

не помогло.
ребутнул, mysql не поднят.
Пользователь решил продолжить мысль 15 Сентября 2009, 19:43:00:

если ставишь из реп, то он автоматом запускается.. прописывается все в rc.d

Код: [Выделить]

sudo apt-get install mysql-server
если есть скрипт в init.d, то можешь установить пакет rcconf, там можешь включить что тебе надо, чтоб поднималось при запуске системы... (команда rcconf)

там и так включен mysql. но все равно при включении компа mysql не поднимается.

[easy2002]

Код: [Выделить]

cat /var/log/syslog | grep mysqlчего пишет?

[m4dn3ss]

(Нажмите, чтобы показать/скрыть)

Код: [Выделить]

Sep 15 18:30:25 m4dn3ss-desktop mysqld[3994]: 090915 18:30:24 [Note] /usr/sbin/mysqld: Normal shutdown
Sep 15 18:30:25 m4dn3ss-desktop mysqld[3994]:
Sep 15 18:30:25 m4dn3ss-desktop mysqld[3994]: 090915 18:30:25  InnoDB: Starting shutdown...
Sep 15 18:30:27 m4dn3ss-desktop mysqld[3994]: 090915 18:30:27  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 18:30:27 m4dn3ss-desktop mysqld[3994]: 090915 18:30:27 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 18:30:27 m4dn3ss-desktop mysqld[3994]:
Sep 15 18:30:27 m4dn3ss-desktop mysqld_safe[21523]: ended
Sep 15 18:31:13 m4dn3ss-desktop kernel: [   17.671256] type=1505 audit(1253025072.248:9): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=2004
Sep 15 18:31:15 m4dn3ss-desktop mysqld_safe[2442]: started
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]: 090915 18:31:16  InnoDB: Started; log sequence number 0 43665
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]: 090915 18:31:16 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]: 090915 18:31:16 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]: 090915 18:31:16 [ERROR] Aborting
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]:
Sep 15 18:31:16 m4dn3ss-desktop mysqld[2446]: 090915 18:31:16  InnoDB: Starting shutdown...
Sep 15 18:31:17 m4dn3ss-desktop mysqld[2446]: 090915 18:31:17  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 18:31:17 m4dn3ss-desktop mysqld[2446]: 090915 18:31:17 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 18:31:17 m4dn3ss-desktop mysqld[2446]:
Sep 15 18:31:17 m4dn3ss-desktop mysqld_safe[2476]: ended
Sep 15 18:31:29 m4dn3ss-desktop /etc/init.d/mysql[2606]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 18:31:29 m4dn3ss-desktop /etc/init.d/mysql[2606]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 18:31:29 m4dn3ss-desktop /etc/init.d/mysql[2606]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 18:31:29 m4dn3ss-desktop /etc/init.d/mysql[2606]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 15 18:31:29 m4dn3ss-desktop /etc/init.d/mysql[2606]:
Sep 15 18:33:27 m4dn3ss-desktop mysqld_safe[4013]: started
Sep 15 18:33:27 m4dn3ss-desktop mysqld[4017]: 090915 18:33:27  InnoDB: Started; log sequence number 0 43665
Sep 15 18:33:27 m4dn3ss-desktop mysqld[4017]: 090915 18:33:27 [Note] /usr/sbin/mysqld: ready for connections.
Sep 15 18:33:27 m4dn3ss-desktop mysqld[4017]: Version: '5.0.75-0ubuntu10.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4055]: Upgrading MySQL tables if necessary.
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4060]: Looking for 'mysql' as: /usr/bin/mysql
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4060]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4060]: This installation of MySQL is already upgraded to 5.0.75, use --force if you still need to run mysql_upgrade
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4069]: Checking for insecure root accounts.
Sep 15 18:33:28 m4dn3ss-desktop /etc/mysql/debian-start[4073]: Triggering myisam-recover for all MyISAM tables
Sep 15 19:12:16 m4dn3ss-desktop mysqld[4017]: 090915 19:12:16 [Note] /usr/sbin/mysqld: Normal shutdown
Sep 15 19:12:16 m4dn3ss-desktop mysqld[4017]:
Sep 15 19:12:16 m4dn3ss-desktop mysqld[4017]: 090915 19:12:16  InnoDB: Starting shutdown...
Sep 15 19:12:17 m4dn3ss-desktop mysqld[4017]: 090915 19:12:17  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:12:17 m4dn3ss-desktop mysqld[4017]: 090915 19:12:17 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:12:17 m4dn3ss-desktop mysqld[4017]:
Sep 15 19:12:17 m4dn3ss-desktop mysqld_safe[5607]: ended
Sep 15 19:13:16 m4dn3ss-desktop kernel: [   30.334495] type=1505 audit(1253027594.908:9): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=2172
Sep 15 19:13:18 m4dn3ss-desktop mysqld_safe[2610]: started
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]: 090915 19:13:18  InnoDB: Started; log sequence number 0 43665
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]: 090915 19:13:18 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]: 090915 19:13:18 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]: 090915 19:13:18 [ERROR] Aborting
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]:
Sep 15 19:13:18 m4dn3ss-desktop mysqld[2614]: 090915 19:13:18  InnoDB: Starting shutdown...
Sep 15 19:13:20 m4dn3ss-desktop mysqld[2614]: 090915 19:13:20  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:13:20 m4dn3ss-desktop mysqld[2614]: 090915 19:13:20 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:13:20 m4dn3ss-desktop mysqld[2614]:
Sep 15 19:13:20 m4dn3ss-desktop mysqld_safe[2644]: ended
Sep 15 19:13:32 m4dn3ss-desktop /etc/init.d/mysql[2774]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 19:13:32 m4dn3ss-desktop /etc/init.d/mysql[2774]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 19:13:32 m4dn3ss-desktop /etc/init.d/mysql[2774]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 19:13:32 m4dn3ss-desktop /etc/init.d/mysql[2774]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 15 19:13:32 m4dn3ss-desktop /etc/init.d/mysql[2774]:
Sep 15 19:15:04 m4dn3ss-desktop mysqld_safe[4131]: started
Sep 15 19:15:04 m4dn3ss-desktop mysqld[4135]: 090915 19:15:04  InnoDB: Started; log sequence number 0 43665
Sep 15 19:15:04 m4dn3ss-desktop mysqld[4135]: 090915 19:15:04 [Note] /usr/sbin/mysqld: ready for connections.
Sep 15 19:15:04 m4dn3ss-desktop mysqld[4135]: Version: '5.0.75-0ubuntu10.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4173]: Upgrading MySQL tables if necessary.
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4178]: Looking for 'mysql' as: /usr/bin/mysql
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4178]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4178]: This installation of MySQL is already upgraded to 5.0.75, use --force if you still need to run mysql_upgrade
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4187]: Checking for insecure root accounts.
Sep 15 19:15:05 m4dn3ss-desktop /etc/mysql/debian-start[4191]: Triggering myisam-recover for all MyISAM tables
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]: 090915 19:24:27 [Note] /usr/sbin/mysqld: Normal shutdown
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]:
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]: 090915 19:24:27  InnoDB: Starting shutdown...
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]: 090915 19:24:27  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]: 090915 19:24:27 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:24:27 m4dn3ss-desktop mysqld[4135]:
Sep 15 19:24:27 m4dn3ss-desktop mysqld_safe[4947]: ended
Sep 15 19:25:23 m4dn3ss-desktop kernel: [   28.194595] type=1505 audit(1253028321.772:9): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=2155
Sep 15 19:25:24 m4dn3ss-desktop mysqld_safe[2570]: started
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]: 090915 19:25:25  InnoDB: Started; log sequence number 0 43665
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]: 090915 19:25:25 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]: 090915 19:25:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]: 090915 19:25:25 [ERROR] Aborting
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]:
Sep 15 19:25:25 m4dn3ss-desktop mysqld[2574]: 090915 19:25:25  InnoDB: Starting shutdown...
Sep 15 19:25:26 m4dn3ss-desktop mysqld[2574]: 090915 19:25:26  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:25:26 m4dn3ss-desktop mysqld[2574]: 090915 19:25:26 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:25:26 m4dn3ss-desktop mysqld[2574]:
Sep 15 19:25:26 m4dn3ss-desktop mysqld_safe[2594]: ended
Sep 15 19:25:38 m4dn3ss-desktop /etc/init.d/mysql[2734]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 19:25:38 m4dn3ss-desktop /etc/init.d/mysql[2734]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 19:25:38 m4dn3ss-desktop /etc/init.d/mysql[2734]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 19:25:38 m4dn3ss-desktop /etc/init.d/mysql[2734]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 15 19:25:38 m4dn3ss-desktop /etc/init.d/mysql[2734]:
Sep 15 19:29:05 m4dn3ss-desktop mysqld_safe[4209]: started
Sep 15 19:29:05 m4dn3ss-desktop mysqld[4213]: 090915 19:29:05  InnoDB: Started; log sequence number 0 43665
Sep 15 19:29:05 m4dn3ss-desktop mysqld[4213]: 090915 19:29:05 [Note] /usr/sbin/mysqld: ready for connections.
Sep 15 19:29:05 m4dn3ss-desktop mysqld[4213]: Version: '5.0.75-0ubuntu10.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4251]: Upgrading MySQL tables if necessary.
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4256]: Looking for 'mysql' as: /usr/bin/mysql
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4256]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4256]: This installation of MySQL is already upgraded to 5.0.75, use --force if you still need to run mysql_upgrade
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4265]: Checking for insecure root accounts.
Sep 15 19:29:06 m4dn3ss-desktop /etc/mysql/debian-start[4269]: Triggering myisam-recover for all MyISAM tables
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]: 090915 19:31:36 [Note] /usr/sbin/mysqld: Normal shutdown
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]:
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]: 090915 19:31:36  InnoDB: Starting shutdown...
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]: 090915 19:31:36  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]: 090915 19:31:36 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:31:36 m4dn3ss-desktop mysqld[4213]:
Sep 15 19:31:36 m4dn3ss-desktop mysqld_safe[4818]: ended
Sep 15 19:32:24 m4dn3ss-desktop kernel: [   21.899313] type=1505 audit(1253028743.476:9): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=2070
Sep 15 19:32:29 m4dn3ss-desktop mysqld_safe[2860]: started
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]: 090915 19:32:30  InnoDB: Started; log sequence number 0 43665
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]: 090915 19:32:30 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]: 090915 19:32:30 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]: 090915 19:32:30 [ERROR] Aborting
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]:
Sep 15 19:32:30 m4dn3ss-desktop mysqld[2864]: 090915 19:32:30  InnoDB: Starting shutdown...
Sep 15 19:32:31 m4dn3ss-desktop mysqld[2864]: 090915 19:32:31  InnoDB: Shutdown completed; log sequence number 0 43665
Sep 15 19:32:31 m4dn3ss-desktop mysqld[2864]: 090915 19:32:31 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 15 19:32:31 m4dn3ss-desktop mysqld[2864]:
Sep 15 19:32:31 m4dn3ss-desktop mysqld_safe[2894]: ended
Sep 15 19:32:43 m4dn3ss-desktop /etc/init.d/mysql[3024]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 19:32:43 m4dn3ss-desktop /etc/init.d/mysql[3024]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 19:32:43 m4dn3ss-desktop /etc/init.d/mysql[3024]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 19:32:43 m4dn3ss-desktop /etc/init.d/mysql[3024]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 15 19:32:43 m4dn3ss-desktop /etc/init.d/mysql[3024]:
Sep 15 19:36:38 m4dn3ss-desktop mysqld_safe[4065]: started
Sep 15 19:36:38 m4dn3ss-desktop mysqld[4069]: 090915 19:36:38  InnoDB: Started; log sequence number 0 43665
Sep 15 19:36:38 m4dn3ss-desktop mysqld[4069]: 090915 19:36:38 [Note] /usr/sbin/mysqld: ready for connections.
Sep 15 19:36:38 m4dn3ss-desktop mysqld[4069]: Version: '5.0.75-0ubuntu10.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4107]: Upgrading MySQL tables if necessary.
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4112]: Looking for 'mysql' as: /usr/bin/mysql
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4112]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4112]: This installation of MySQL is already upgraded to 5.0.75, use --force if you still need to run mysql_upgrade
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4121]: Checking for insecure root accounts.
Sep 15 19:36:39 m4dn3ss-desktop /etc/mysql/debian-start[4125]: Triggering myisam-recover for all MyISAM tables


[arrecck]

а какой адрес и порт для mysql сервера в /etc/mysql/my.cnf ?