my notes

User Tools

Site Tools

Trace: • bittorrentclientonlinux
mysqladmin

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysqladmin [2016/12/16 02:54] – [Install from source] adminmysqladmin [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 38: Line 38:
   - Step7: Init database<code bash>   - Step7: Init database<code bash>
 cd /onec/mysql cd /onec/mysql
-scripts/mysql_install_db --user=mysql+scripts/mysql_install_db --datadir=/onec/mysql/data --user=mysql
 </code> </code>
   - Step8: Start Server:<code bash>   - Step8: Start Server:<code bash>
Line 49: Line 49:
   - Step9: Login to Mysql server<code bash>   - Step9: Login to Mysql server<code bash>
 mysql -uroot mysql -uroot
 +</code>
 +  - Step10: Reset password root<code bash>
 +mysqladmin password 'newpassword'
 </code> </code>
 ==== Installing MySQL on Microsoft Windows Using a noinstall Zip Archive ==== ==== Installing MySQL on Microsoft Windows Using a noinstall Zip Archive ====
Line 66: Line 69:
 bin\mysqld --initialize bin\mysqld --initialize
 bin\mysqld --initialize-insecure bin\mysqld --initialize-insecure
-</code>output: Init database mysql in data directory **d:\\tools\\mysql-5.7.13-winx64\data**. And with option --initialize, we check log **.err** in data directory to see temporary password for root:<code> +</code>output: Init database mysql in data directory **d:\\tools\\mysql-5.7.13-winx64\data**. And with option **--initialize**, we check log **.err** in data directory to see **temporary password for root**:<code>A temporary password is generated for root@localhost: 8mfak!jsyltB 
-A temporary password is generated for root@localhost: 8mfak!jsyltB+</code>With old version:<code bash> 
 +./scripts/mysql_install_db --user=mysql 
 +./bin/mysql_secure_installation -> set password for mysql
 </code> </code>
   - Step5: Start the MySQL server:<code bat>   - Step5: Start the MySQL server:<code bat>
Line 200: Line 205:
 SHOW CREATE PROCEDURE `sp_gold_update_transaction`; SHOW CREATE PROCEDURE `sp_gold_update_transaction`;
 </code> </code>
 +  * change definer to **root@localhost** before import sql from sql dump file
 ==== Create database from script .sql ==== ==== Create database from script .sql ====
 commands:<code bash> commands:<code bash>
Line 392: Line 398:
 </code> </code>
 ==== Query log of mysql server ==== ==== Query log of mysql server ====
-  * [windows]<code>+  * [windows] (You must go to **services.msc** and select service MySQL Server to see the **path of my.ini**)<code>
 [mysqld] [mysqld]
 ....... .......
Line 465: Line 471:
 ===== Tunning Mysql Server ===== ===== Tunning Mysql Server =====
 Before run script check, we need to run automatic all pages of websites for running all queries in mysql Before run script check, we need to run automatic all pages of websites for running all queries in mysql
 +==== MySQL table limit ====
 +https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/column-count-limit.html
 ==== Run script check ==== ==== Run script check ====
 Download script from https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl and run:<code bash> Download script from https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl and run:<code bash>
Line 699: Line 707:
 </code> </code>
     * step2: Loading this file using:<code bash>     * step2: Loading this file using:<code bash>
-mysql  -f --default-character-set=utf8 -u username -p backup_mysql < backup.sql+mysql  -f --default-character-set=utf8 --routines -u username -p backup_mysql < backup.sql
 </code> </code>
 ==== Use the mysqlhotcopy script ==== ==== Use the mysqlhotcopy script ====
mysqladmin.1481856883.txt.gz · Last modified: (external edit)