Differences

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

--- mysqladmin [2018/01/03 06:51] – [Show tables and procedure information] admin
+++ mysqladmin [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 38: / Line 38: @@
   - Step7: Init database<code bash>
 cd /onec/mysql
-scripts/mysql_install_db --user=mysql
+scripts/mysql_install_db --datadir=/onec/mysql/data --user=mysql
 </code>
   - Step8: Start Server:<code bash>
@@ Line 69: / Line 69: @@
 bin\mysqld --initialize
 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>
   - Step5: Start the MySQL server:<code bat>
@@ Line 469: / Line 471: @@
 ===== Tunning Mysql Server =====
 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 ====
 Download script from https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl and run:<code bash>
@@ Line 703: / Line 707: @@
 </code>
     * 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>
 ==== Use the mysqlhotcopy script ====