my notes

User Tools

Site Tools

Trace: • architecture • drupal
mysqladmin

Differences

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

Link to this comparison view

mysqladmin [2016/12/15 10:53] – [Install from source] adminmysqladmin [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 8: Line 8:
 ==== Install from source ==== ==== Install from source ====
 refer:  refer: 
-  * http://dev.mysql.com/doc/refman/5.6/en/source-installation.html +  * http://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html 
-  * https://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html +  * http://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
-  * http://howtolamp.com/lamp/mysql/5.6/installing/+
 Download source: Plsease select Generic Linux (Architecture Independent), Compressed TAR Archive package for download Download source: Plsease select Generic Linux (Architecture Independent), Compressed TAR Archive package for download
   * newest source: https://dev.mysql.com/downloads/mysql/   * newest source: https://dev.mysql.com/downloads/mysql/
   * version 5.6: https://dev.mysql.com/downloads/mysql/5.6.html#downloads   * version 5.6: https://dev.mysql.com/downloads/mysql/5.6.html#downloads
-Below are steps to install MySQL Server:+Below are steps to install MySQL Server **5.6.35**:
   - Step1: Add mysql user:<code bash>   - Step1: Add mysql user:<code bash>
 useradd -r -U mysql -M -d /onec/mysql/data useradd -r -U mysql -M -d /onec/mysql/data
Line 35: Line 34:
   - Step5:chown to mysql:<code bash>   - Step5:chown to mysql:<code bash>
 chown -R mysql.mysql /onec/mysql chown -R mysql.mysql /onec/mysql
 +</code>
 +  - Step6: copy my.cnf to /etc/my.cnf
 +  - Step7: Init database<code bash>
 +cd /onec/mysql
 +scripts/mysql_install_db --datadir=/onec/mysql/data --user=mysql
 +</code>
 +  - Step8: Start Server:<code bash>
 +bin/mysqld_safe --user=mysql &
 +</code>or start with scripts:<code bash>
 +# Next command is optional
 +cp support-files/mysql.server /etc/init.d/mysql.server
 +/etc/init.d/mysql.server start
 +</code>
 +  - Step9: Login to Mysql server<code bash>
 +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 52: 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 186: 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 378: 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 451: 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 685: 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.1481799228.txt.gz · Last modified: 2022/10/29 16:15 (external edit)