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 [2025/05/15 12:47] val [Debian/Ubuntu] |
сервис_mysql [2025/06/30 06:41] (current) val [Debian/Ubuntu] |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ==== Debian/Ubuntu ==== | ==== Debian/Ubuntu ==== | ||
| + | * !!! от 2GB RAM | ||
| * на все вопросы о пароле пользователя root нажимаем "Enter" | * на все вопросы о пароле пользователя root нажимаем "Enter" | ||
| * ставится 3-4 минуты | * ставится 3-4 минуты | ||
| Line 99: | Line 100: | ||
| <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 --skip-column-names -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 133: | 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.1747302474.txt.gz · Last modified: 2025/05/15 12:47 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
