Fulltext results:

MySQLコマンド

7 Hits, Last modified: 2 months ago

| | % | test\_% | | | 172.16.0.3 | mc_portal | mc_portal | | 172.20.0.35 | m... ==== <code> mysql> RENAME USER 'FROM_USER'@'192.168.0.%' TO 'TO_USER'@'192.168.1.%'; </code> ===== ②データベース関連 ===== ==== データベース作成 ==== <code console> ... | | | User | varchar(16) | NO | PRI | |

外部接続

7 Hits, Last modified: 13 years ago

ailuser パスワード：vpopmailpass DB:vpopmail\\ HOSTは192.168.1.% \\ ※%はワイルドカード。この場合192.168.1.のネットワークからの接続の意味。\\ <code console> mysql> GRANT ALL ON vpopmail. * TO vpopmailuser@'192.168.1.%' IDENTIFIED BY "vpopmailpass"; Query OK, 0 ... | 3cf31278467575ed | | vpopmailuser | 192.168.1.% | 7d60b94d42e45b72 | +-------------

MySQL - レプリケーション

2 Hits, Last modified: 13 years ago

code> server-id = 2 master-host = 172.16.8.53 master-port = 3306 master-user = s... to send event Master_Host: 172.16.8.53 Master_User: slave

MySQL - バックアップ mysqldump

2 Hits, Last modified: 7 months ago

mysqldump --all-databases | ssh -i key root@192.168.10.10 'cat > dump.sql' ==== リモートへ圧縮してコピー ==== ... dump --all-databases | gzip | ssh -i key root@192.168.10.10 'cat > dump.sql.gz' ==== リモートへSSHしてからdum

mysqldumpでエラー

2 Hits, Last modified: 12 years ago

-tables -u hogehoge --password="hogehoge" -h "192.168.10.10" cloud > cloud.dump mysqldump: Couldn't e... : SHOW VIEW command denied to user 'hogehoge@'192.168.10.10 for table 'account_netstats_view' (1142) <

15 MySQL 55 to 56 で問題

1 Hits, Last modified: 3 years ago

is running in --secure-auth mode, but 'user'@'192.168.*.*' has a password in the old format; please ch

16 mysql community からyum

1 Hits, Last modified: 8 years ago

====== 16 mysql community からyum ====== CentOS5 # rpm -ivh http://dev.mysql.com/get/mysql-community-

IPアドレス-アドレスナンバー

1 Hits, Last modified: 12 years ago

0.3') | +------------------------+ | 168427523 | +------------------------+ 1 row in set