This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
сервис_mysql [2018/08/30 14:19] val [Управление сбоями] |
сервис_mysql [2020/10/06 14:55] val [Из командной строки] |
||
---|---|---|---|
Line 9: | Line 9: | ||
<code> | <code> | ||
- | root@server:~# apt install mysql-server | + | debian10# apt install default-mysql-server |
+ | |||
+ | server# apt install mysql-server | ||
</code> | </code> | ||
Line 45: | Line 47: | ||
</code> | </code> | ||
+ | ===== Управление параметрами сервера ===== | ||
+ | |||
+ | <code> | ||
+ | # cat /etc/mysql/conf.d/my-custom-settings.cnf | ||
+ | </code><code> | ||
+ | [mysqld] | ||
+ | sql_mode="" | ||
+ | innodb_strict_mode=OFF | ||
+ | </code><code> | ||
+ | # service mysql restart | ||
+ | </code> | ||
===== Смена пароля пользователя root ===== | ===== Смена пароля пользователя root ===== | ||
Line 76: | Line 89: | ||
==== Из командной строки ==== | ==== Из командной строки ==== | ||
<code> | <code> | ||
- | # mysql billing -u billing --password=XXX -B --skip-column-names -e "select login, pass from accounts where uid=YYY" | + | # mysql billing -u billing --password=XXX -B --skip-column-names -e "select login, pass from accounts where uid=YYY" | tr '\t' ';' |
</code> | </code> | ||
===== Управление базами данных и пользователями ===== | ===== Управление базами данных и пользователями ===== | ||
Line 144: | Line 157: | ||
===== adminer ===== | ===== adminer ===== | ||
- | |||
- | Попробовать | ||
* [[https://www.adminer.org/]] | * [[https://www.adminer.org/]] | ||
Line 151: | Line 162: | ||
<code> | <code> | ||
# apt install adminer | # apt install adminer | ||
+ | |||
+ | # cat /etc/apache2/sites-available/000-default.conf | ||
+ | </code><code> | ||
+ | ... | ||
+ | Alias /adminer /usr/share/adminer/adminer/ | ||
+ | ... | ||
</code> | </code> | ||
Line 163: | Line 180: | ||
# less /etc/phpmyadmin/apache.conf | # less /etc/phpmyadmin/apache.conf | ||
+ | </code><code> | ||
+ | http://server.corpX.un/phpmyadmin | ||
</code> | </code> | ||
- | |||
- | * http://server.corpX.un/phpmyadmin | ||
- | |||
===== Управление сбоями ===== | ===== Управление сбоями ===== | ||