• mysql8学习笔记2-非常规安装


    承接之前的常规安装,如果想把data目录迁移到别的路径下,可以这么操作:

    [root@localhost mysql]# /etc/init.d/mysql stop #首先关闭应用
    Shutting down MySQL.. SUCCESS! 
    [root@localhost mysql]# mv ./data /mysql_data #然后迁移data
    [root@localhost mysql]# /etc/init.d/mysql start #启动下报错了。
    Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
     ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
    [root@localhost mysql]# vim /etc/my.cnf #修改配置文件,没有就创建,设置目录
    [root@localhost mysql]# cat /etc/my.cnf
    [mysqld]
    datadir=/mysql_data
    [root@localhost mysql]# /etc/init.d/mysql start #启动成功
    Starting MySQL.. SUCCESS! 
    [root@localhost mysql]# 

    也可以把整个mysql路径都迁移

    [root@localhost mysql]# /etc/init.d/mysql stop
    Shutting down MySQL.. SUCCESS! 
    [root@localhost mysql]# cd ..
    [root@localhost local]# mv mysql /mysql
    [root@localhost local]# ls
    bin  etc  games  include  lib  lib64  libexec  sbin  share  src
    [root@localhost local]# vim /etc/my.cnf
    [root@localhost local]# cat /etc/my.cnf
    [mysqld]
    basedir=/mysql #添加一个mysql路径
    datadir=/mysql_data
    [root@localhost local]# /etc/init.d/mysql start
    Starting MySQL.. SUCCESS! 
    [root@localhost local]# ps -ef |grep mysql
    root      70568      1  0 02:01 pts/2    00:00:00 /bin/sh /mysql/bin/mysqld_safe --datadir=/mysql_data --pid-file=/mysql_data/localhost.localdomain.pid
    mysql     70682  70568 11 02:01 pts/2    00:00:00 /mysql/bin/mysqld --basedir=/mysql --datadir=/mysql_data --plugin-dir=/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/mysql_data/localhost.localdomain.pid
    root      70728  11777  0 02:01 pts/2    00:00:00 grep --color=auto mysql
    [root@localhost local]# 

    也可以在初始化时指定路径

    [root@localhost /]# mkdir mysql8 创建新目录
    [root@localhost /]# mv mysql ./mysql8/ #迁移mysql路径
    [root@localhost /]# mv mysql_data ./mysql8/ #迁移mysqldata路径
    [root@localhost /]# ls /mysql8/
    mysql  mysql_data
    [root@localhost /]# ls
    bin  boot  dev  etc  home  lib  lib64  media  mnt  mysql8  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
    [root@localhost /]# rm -rf ./mysql8/mysql_data/* #删除mysqldata下数据
    [root@localhost /]# cd mysql8/mysql/
    [root@localhost mysql]# pwd
    /mysql8/mysql
    [root@localhost mysql]# bin/mysqld --initialize --user=mysql --basedir=/mysql8/mysql --datadir=/mysql8/mysql_data & #重新初始化,指定basedir和datadir
    [1] 71600
    [root@localhost mysql]# 2020-06-27T10:12:02.279902Z 0 [System] [MY-013169] [Server] /mysql8/mysql/bin/mysqld (mysqld 8.0.13) initializing of server in progress as process 71600
    2020-06-27T10:12:08.432323Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: aj.+bS%6&!4m
    2020-06-27T10:12:12.310996Z 0 [System] [MY-013170] [Server] /mysql8/mysql/bin/mysqld (mysqld 8.0.13) initializing of server has completed
    
    [1]+  Done                    bin/mysqld --initialize --user=mysql --basedir=/mysql8/mysql --datadir=/mysql8/mysql_data
    [root@localhost mysql]# mysql -uroot -p
    -bash: /usr/local/mysql/bin/mysql: No such file or directory
    [root@localhost mysql]# vim ~/.bash_profile 
    [root@localhost mysql]# cat ~/.bash_profile |grep PATH
    PATH=$PATH:$HOME/bin:/mysql8/mysql/bin
    export PATH
    [root@localhost mysql]# source ~/.bash_profile 
    [root@localhost mysql]# mysql -uroot -p
    Enter password: 
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    [root@localhost mysql]# /etc/init.d/mysql start
    /etc/init.d/mysql: line 239: my_print_defaults: command not found
    /etc/init.d/mysql: line 259: cd: /usr/local/mysql: No such file or directory
    Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)
    [root@localhost mysql]# vim /etc/my.cnf
    [root@localhost mysql]# cat /etc/my.cnf
    [mysqld]
    basedir=/mysql8/mysql
    datadir=/mysql8/mysql_data
    [root@localhost mysql]# /etc/init.d/mysql start
    Starting MySQL.Logging to '/mysql8/mysql_data/localhost.localdomain.err'.
    .. SUCCESS! 
    [root@localhost mysql]# mysql -uroot -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or g.
    Your MySQL connection id is 8
    Server version: 8.0.13
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
    
    mysql> alter user user() identified by 'mysql';
    Query OK, 0 rows affected (0.03 sec)
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    | sys                |
    +--------------------+
    4 rows in set (0.01 sec)
    
    mysql> 
  • 相关阅读:
    (圆形imageview 类似qq头像)---》(ps:引用第三库APAvatarImageView>
    uiscrollerview循环滚动(参考第三方库:HMBannerView)https://github.com/iunion/autoScrollBanner
    iOS -动态可变参数
    ios-UIPickerView基本使用
    iOS 实现进度条(progress)
    @property (nonatomic, getter = isExpanded) BOOL expanded;
    linker command failed with exit code 1 (use -v to see invocation)
    APICloud界面间跳转
    iOS CGRectGetMaxY/CGRectGetMaxX
    iOS UIView常用的一些方法setNeedsDisplay和setNeedsLayout 区别
  • 原文地址:https://www.cnblogs.com/laonicc/p/13199346.html
Copyright © 2020-2023  润新知