mysqld  --defaults-file=/etc/mysql/my2.cnf  --initialize --user=mysql
       mysql_ssl_rsa_setup --datadir=/var/lib/mysql2
       mysqld_safe  --defaults-file=/etc/mysql/my2.cnf &
   

 
ps ax
  PID TTY      STAT   TIME COMMAND
    1 pts/0    Ss+    0:00 bash
  376 pts/1    S      0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my2.cnf
  609 pts/1    Sl     0:07 /usr/sbin/mysqld --defaults-file=/etc/mysql/my2.cnf --basedir=/usr --datadir=/var/lib/mysql2 --plugin-dir=/usr/lib/mysql/plugin --user
  664 pts/1    R+     0:00 ps ax

mysql   --socket=/var/run/mysqld/mysqld2.sock --protocol=socket
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

  
[mysqld]
pid-file        = /var/run/mysqld/mysqld2.pid
socket          = /var/run/mysqld/mysqld2.sock
datadir         = /var/lib/mysql2

port            		= 3307
basedir         		= /usr

tmpdir          		= /tmp

#user             = mysql

log-bin           = /var/log/mysql2/mysql-bin.log
log-error         = /var/log/mysql2/error.log

bind-address            	= 0.0.0.0

secure-file-priv= NULL

mysqladmin  --defaults-file=/etc/mysql/my2.cnf  -u root password '1234'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

mysql> select user,host,authentication_string from user ;
+------------------+-----------+------------------------------------------------------------------------+
| user             | host      | authentication_string                                                  |
+------------------+-----------+------------------------------------------------------------------------+
| mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root             | localhost | $A$005$F>w^_v63xqhjr`A6Si/BsEsXPkGg0Ve91d6zFaQJFlyFwdt/27m4.61z98 |
+------------------+-----------+------------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql> SET PASSWORD  = '12345';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

FLUSH PRIVILEGIES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

CREATE USER user  IDENTIFIED WITH mysql_native_password BY '12345';