my notes

User Tools

Site Tools

Trace:
mysqladmin

Differences

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

Link to this comparison view

mysqladmin [2017/03/14 06:20] – [Installing MySQL on Microsoft Windows Using a noinstall Zip Archive] 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 69: 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 203: 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 395: 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 468: 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 702: 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.1489472413.txt.gz · Last modified: 2022/10/29 16:15 (external edit)