• на все вопросы о пароле пользователя root нажимаем “Enter”

root@server:~# apt install mysql-server

freebsd10# pkg install mysql56-server

[server:~] # service mysql-server rcvar

[server:~] # service mysql-server start

http://dev.mysql.com/downloads/installer/

или

http://www.apachefriends.org/en/xampp.html

shell> cd C:\xampp\mysql\bin\

# cat /etc/mysql/conf.d/utf8.cnf

[mysqld]
collation_server=utf8_general_ci
character_set_server=utf8
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
skip-character-set-client-handshake

• How to reset your MariaDB root password?
• Change user password in MySQL 5.7 with “plugin: auth_socket”

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678';

# mysqladmin --user=root password somepassword

# mysqladmin --user=root --password reload

# mysql -u root -p

Welcome to the MySQL monitor.  Commands end with ; or \g.
...
mysql> exit

# mysql billing -u billing --password=XXX -B --skip-column-names -e "select login, pass from accounts where uid=YYY"

mysql> show databases;

mysql> use mysql;

shell> mysql -u root -p

mysql> CREATE DATABASE cacti;

mysql> exit;

или

shell> mysqladmin -u root -p create cacti

windows> mysql -u root -p cacti < C:\xampp\htdocs\cacti\cacti.sql

или

freebsd# mysql cacti < /usr/local/share/cacti/cacti.sql

или

ubuntu# zcat /usr/share/doc/cacti/cacti.sql.gz | mysql -p cacti

mysql> GRANT ALL PRIVILEGES ON cacti.* TO "cactiuser"@"localhost" IDENTIFIED BY "cactiuser";

mysql> GRANT SELECT (uuid,login,name) ON billing.accounts to user1@localhost;

mysql> FLUSH PRIVILEGES;

mysql> exit;

shell> mysql -u cactiuser -p cacti
Enter password: cactiuser

# cat /etc/mysql/mariadb.conf.d/50-server.cnf

...
[mysqld]
...
general-log
general-log-file=/var/log/mysql/q.log
log-output=file
...

# apt install phpmyadmin

# ls -l /etc/apache2/conf-available/phpmyadmin.conf

# less /etc/phpmyadmin/apache.conf

• http://server.corpX.un/phpmyadmin

• Можно в консоли сервера запустить mysqlcheck -r, он автоматически починит проблемные таблицы во всех базах.
• SHOW PROCESSLIST Syntax