Answer the question
In order to leave comments, you need to log in
Unable to set password for the MySQL "root" user?
I can’t install mysql, from the beginning I wanted to reinstall it, removed everything related to mysql and started installing it again, but during installation I got only:
131209 5:19:47 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Configuring mysql-server-5.5
----------------------------
Unable to set password for the MySQL "root" user
An error occurred while setting the password for the MySQL administrative user. This may have happened because the account already has a password, or because of a communication problem with
the MySQL server.
You should check the account's password after the package installation.
Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for more information.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2).
Answer the question
In order to leave comments, you need to log in
Remove everything related to MySQL again. After that delete mysql-related files manually, for example, like this:
And after that install the MySQL server again, everything will work out.
apt-get -y remove mysql-server
rm -rf /var/lib/mysql* /etc/mysql*
apt-get -y install mysql-server
If the issue is still relevant.
Try adding innodb_use_native_aio = 0 to /etc/mysql/my.cnf under [mysqld] and try again.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question