• ResetMysqlRootPassword . . . . 13 matches
       #keywords mysql
       https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
       /var/log/mysql/error.log
       sudo mysql -uroot -p
        * this can be read by mysql
       sudo mysqld --init-file=/home/me/mysql-init &
       sudo kill `cat /var/run/mysqld/mysqld.pid`
       5.reset in mysql client
       $ mysql
       mysql> FLUSH PRIVILEGES;
       mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
• RemoveMysqlDataAndRootPassword . . . . 8 matches
       [mysql] >
       !!! WARN !!! this will delete whole mysql data and account
       sudo service mysql stop
       sudo rm -rf /var/lib/mysql
       sudo /usr/sbin/mysqld --initialize-insecure
       sudo service mysql start
       mysql -uroot -p
       mysql> alter user root@localhost identified by 'myNewPassword';
• ResetMysqlInitialRootPassword . . . . 7 matches
       #keywords mysql, password, root
       $ grep password /var/log/mysql/error.log
        * connect mysql as a root user and initialize
       $ sudo mysql -uroot
       mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password;
       $ mysqladmin --user=root password
• mysql . . . . 6 matches
       #keywords mysql
       [remove mysql data and root password]
       [reset mysql root password]
       [reset mysql initial root password]
       [mysql bulk insert]
       [linux]에서 [배치로 Mysql Db 백업받기]
       [mysql cli에 vi editor 모드 설정]
• spark . . . . 5 matches
       = from mysql =
       val df_mysql = sqlContext.read.format("jdbc").option("url", "jdbc:mysql://dev-db/finance").option("driver", "com.mysql.jdbc.Driver").option("dbtable", "(select a.*,b.productBaseDetailSeq,b.optionSrl,b.paymentSrl,b.amount,b.salesSupplyFee,b.salesSupplyFeeVat,b.paymentSupplyFee,b.paymentSupplyFeeVat,b.count from product_base a join product_base_detail b on a.productBaseSeq=b.productBaseSeq) as prbase").option("user", "ididid").option("password", "xxxxx").load()
       df_mysql.registerTempTable("prbase")
• systemd . . . . 5 matches
       ref. DisableMysqlRunAtBootTime
       sudo systemctl {start|stop|restart|status} mysql
       sudo systemctl disable mysql
       service mysqld {start|stop|restart|status}
       systemctl enable mysqld@replica01
       systemctl enable mysqld@replica02
• 배치로MysqlDb백업받기 . . . . 5 matches
       #keywords mysql, backup, batch
        *[mysql] db 백업받는 스크립트를 만들어 매일 수행되도록 [linux] 크론에 등록하는 과정
       [mysql 복구]
       /usr/local/mysql/bin/mysqldump -u USER_ID --password=PASSWD DB_NAME > db_dump_`date +%Y%m%d`
• ExpectScript/mycliViaSshTunneling . . . . 4 matches
       set mysql_tnl_port [lindex $argv 2]
       set mysql_host [lindex $argv 3]
       spawn ssh -oStrictHostKeyChecking=no -f -p${ssh_tnl_port} bok@localhost.fin -L${mysql_tnl_port}:${mysql_host}:3306 sleep 10
• Mysql복구 . . . . 4 matches
       #keywords mysql, restore, backup
       [mysqldump] 를 이용해 백업해두었던 파일로 복구하기
       [mysql], [배치로 Mysql Db 백업받기]
       mysql < dump.sql
• DisableMysqlRunAtBootTime . . . . 3 matches
       #keywords mysql, systemctl, systemd, autostart, disable
       sudo systemctl {start|stop|restart|status} mysql
       sudo systemctl disable mysql
• MysqlCli에ViEditor모드설정 . . . . 3 matches
       #keywords mysql, mysql_client, mysql-cli, vi, vim, editrc, repl, inputrc
• SparkPerformanceTestResultsOnCluster . . . . 3 matches
        - mysql sql : 2m12s
        - mysql sql : 2m4s
        - mysql sql : 2m5s
• DisableDockerDaemonRunAtBootTime . . . . 1 match
       ref : [disable mysql run at boot time]
• LinuxTips . . . . 1 match
       = [배치로 mysql db 백업받기] =
• MyBatisError . . . . 1 match
       원인 : 이상한 오류가 나온 점에 대한 원인은 아직 모르겠고.. 오류가 난 원인은 int type의 mysql 쿼리 결과가 null 이었는데 이걸 result object에 mapping 할 때 나는 오류였음.
• MysqlBulkInsert . . . . 1 match
       #keywords mysql, disabling index, bulk insert
• SystemV . . . . 1 match
       service mysql {start|stop|restart|status}
• 구글검색옵션 . . . . 1 match
       “#mysql dump" filetype:sql

You can also click here to search title.