User Tools
сервис_mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
сервис_mysql [2021/03/12 10:34] val |
сервис_mysql [2025/11/26 06:42] (current) val [Из командной строки] |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ==== Debian/Ubuntu ==== | ==== Debian/Ubuntu ==== | ||
| + | * !!! от 2GB RAM | ||
| * на все вопросы о пароле пользователя root нажимаем "Enter" | * на все вопросы о пароле пользователя root нажимаем "Enter" | ||
| * ставится 3-4 минуты | * ставится 3-4 минуты | ||
| <code> | <code> | ||
| - | debian10# apt install default-mysql-server | + | # apt install default-mysql-server |
| - | + | ||
| - | server# apt install mysql-server | + | |
| </code> | </code> | ||
| Line 68: | Line 67: | ||
| MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password; | MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password; | ||
| - | MariaDB [(none)]> SET PASSWORD = PASSWORD('ewsgh3sd'); | + | MariaDB [(none)]> SET PASSWORD = PASSWORD('12345678'); |
| # service mysql restart | # service mysql restart | ||
| Line 100: | Line 99: | ||
| ==== Из командной строки ==== | ==== Из командной строки ==== | ||
| <code> | <code> | ||
| - | # mysql billing -u billing --password=XXX -B --skip-column-names -e "select login, pass from accounts where uid=YYY" | tr '\t' ';' | + | # mysql billing -u billing --password=XXX -B -N -e "select login, pass from accounts where uid=YYY" | tr '\t' ';' |
| + | </code> | ||
| + | |||
| + | ==== По сети ==== | ||
| + | |||
| + | * [[https://serverfault.com/questions/483339/changing-host-permissions-for-mysql-users]] | ||
| + | |||
| + | <code> | ||
| + | # cat /etc/mysql/mysql.conf.d/mysqld.cnf | ||
| + | </code><code> | ||
| + | #... | ||
| + | bind-address = * | ||
| + | mysqlx-bind-address = * | ||
| + | #... | ||
| + | </code><code> | ||
| + | # service mysql restart | ||
| + | |||
| + | # mysql | ||
| + | </code><code> | ||
| + | SELECT User, Host FROM mysql.user; | ||
| + | SELECT User, Host FROM mysql.db; | ||
| + | |||
| + | UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='asterisk'; | ||
| + | UPDATE mysql.db SET Host='%' WHERE Host='localhost' AND User='asterisk'; | ||
| + | |||
| + | FLUSH PRIVILEGES; | ||
| + | </code><code> | ||
| + | # mysql -h server.corp24.un -u asterisk -p asterisk | ||
| </code> | </code> | ||
| ===== Управление базами данных и пользователями ===== | ===== Управление базами данных и пользователями ===== | ||
| Line 135: | Line 161: | ||
| или | или | ||
| - | ubuntu# zcat /usr/share/doc/cacti/cacti.sql.gz | mysql -p cacti | + | ubuntu# zcat /usr/share/doc/cacti/cacti.sql.gz | mysql -p -v cacti |
| </code> | </code> | ||
сервис_mysql.1615534466.txt.gz · Last modified: 2021/03/12 10:34 by val
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
