проблема с mysql после обнавления

[Bilalline]

bilalline@bilalline-MSI:~$ sudo service mysql start
[sudo] password for bilalline:
start: Job failed to start
bilalline@bilalline-MSI:~$ service mysql start
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.77" (uid=1000 pid=4728 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")

[victor00000]

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

ls -ld /var/log/mysql?

[Bilalline]

:~$ ls -ld /var/log/mysql
drwxr-s--- 2 mysql adm 4096 сент.  3 13:04 /var/log/mysql

[victor00000]

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

cat cat /etc/mysql/my.cnf | grep ^bind
sudo /usr/bin/mysql_install_db?

[Bilalline]

:~$ cat /etc/mysql/my.cnf | grep ^bind
bind-address            = 127.0.0.1
:~$ sudo /usr/bin/mysql_install_db
[sudo] password for bilalline:
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h bilalline-MSI password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/scripts/mysqlbug script!

[victor00000]

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

cat /var/log/mysql.err | tail
cat /var/log/mysql.log | tail?

[Bilalline]

даже не знаю что и сказать
:~$ cat /var/log/mysql.err | tail
:~$ cat /var/log/mysql.log | tail
пусто

[victor00000]

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

nano /etc/mysql/my.cnfнайти

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

# As of 5.1 you can enable the log at runtime!заменить

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

# As of 5.1 you can enable the log at runtime!
log = /var/log/mysql/mysql.log
сохранить и перезапустить мусял.

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

sudo service mysql startи лог

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

cat /var/log/mysql/mysql.log

[Bilalline]

bilalline@bilalline-MSI:~$ sudo service mysql start
start: Job failed to start
bilalline@bilalline-MSI:~$ cat /var/log/mysql/mysql.log
cat: /var/log/mysql/mysql.log: Нет такого файла или каталога
Пользователь решил продолжить мысль 07 Октября 2012, 21:20:38:если его удалить и заново поставить база останется или слетит?

[victor00000]

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

sudo dpkg-reconfigure mysql-server-5.5

[Bilalline]

Спасибо помогло

[dj--alex]

А вот мне не помогло::

root@al-desktop:/etc/mysql# sudo dpkg-reconfigure mysql-server-5.1
stop: Unknown instance:
140416  3:51:51 [Warning] option 'expire_logs_days': unsigned value 100 adjusted to 99
start: Job failed to start

[victor00000]

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

sudo grep -rs expire_logs_days /etc