All commands needs to run as user root
or via sudo
.
apt-get update
apt-get install mysql-server
Enter a strong password, for the MySQL root
user:
If the installation is completed, you should be able to login to the MySQL server
with the command mysql -p
.
service mysql stop
echo "innodb_log_file_size = 512M" >> /etc/mysql/mysql.conf.d/mysqld.cnf
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
service mysql start
Cool down. You can use the debian-sys-maint
to reset your root password.
mysql --defaults-extra-file=/etc/mysql/debian.cnf