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/06/20 12:13] 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 минуты | ||
| Line 98: | 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> | </code> | ||
| Line 114: | Line 115: | ||
| </code><code> | </code><code> | ||
| # service mysql restart | # service mysql restart | ||
| - | </code><code> | + | |
| # mysql | # mysql | ||
| </code><code> | </code><code> | ||
| Line 122: | Line 123: | ||
| UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='asterisk'; | UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='asterisk'; | ||
| UPDATE mysql.db SET Host='%' WHERE Host='localhost' AND User='asterisk'; | UPDATE mysql.db SET Host='%' WHERE Host='localhost' AND User='asterisk'; | ||
| + | |||
| FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
| </code><code> | </code><code> | ||
| Line 159: | 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.1750410829.txt.gz · Last modified: 2025/06/20 12:13 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
