Differences

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

--- mysqladmin [2018/05/05 11:50] – [Tunning Mysql Server] 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 705: / 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 ====