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 15:23] val [MariaDB] |
сервис_mysql [2025/06/23 14:21] (current) val [Импорт данных] |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| <code> | <code> | ||
| - | debian10# apt install default-mysql-server | + | # apt install default-mysql-server |
| - | + | ||
| - | server# apt install mysql-server | + | |
| </code> | </code> | ||
| Line 68: | Line 66: | ||
| 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('........'); | + | MariaDB [(none)]> SET PASSWORD = PASSWORD('12345678'); |
| # service mysql restart | # service mysql restart | ||
| Line 101: | 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 --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 135: | Line 160: | ||
| или | или | ||
| - | 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.1615551828.txt.gz · Last modified: 2021/03/12 15:23 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
