• Linux yum 安装Java和MySQL


    更多内容参见个人技术博客,无广告欢迎关注

    1、Linux配置Java环境

    CentOS系统默认是带有yum(软件包依赖管理工具)的,Ubuntu是apt,macOS是homebrew

    yum -y update 升级所有包同时也升级软件和系统内核

    yum -y upgrade 只升级所有包,不升级软件和系统内核

    安装之前先检查一下系统有没有自带open-jdk

    rpm -qa |grep java

    rpm -qa |grep jdk

    rpm -qa |grep gcj

    如果没有输入信息表示没有安装。

    如果安装可以使用 rpm -qa | grep java | xargs rpm -e --nodeps 批量卸载所有带有Java的文件  这句命令的关键字是java

    yum list java*  检索包含java的列表

    yum install java-1.8.0-openjdk* -y  安装1.8.0的所有文件


    java -version  检查是否安装成功(yum安装都不用配置环境变量)

    2、Linux配置MySQL

    yum安装MySQL,主要是3个包

    mysql-devel 开发用到的库以及包含文件
    mysql mysql 客户端
    mysql-server 数据库服务器

    安装之前,先说收如何彻底卸载MySQL

    用命令rpm -qa|grep -i mysql查看已经安装的MySQL安装包,在列表中逐个卸载

    yum remove mysql mysql-server mysql-libs compat-mysql51 

    rm -rf /var/lib/mysql  

    rm /etc/my.cnf

    查看以前是否安装过

    yum list installed mysql*

    rpm -qa | grep mysql*

    安装MySQL

    yum install mysql

    yum install mysql-server

    yum install mysql-devel

    配置MySQL

    [root@wood /]# cat /etc/my.cnf

    [client]

    default-character-set=utf8

     

    [mysql]

    default-character-set = utf8

     

    [mysqld]

    character_set_server=utf8

    character_set_client=utf8

    collation-server=utf8_general_ci

    max_connections=100

    datadir=/var/lib/mysql

    socket=/var/lib/mysql/mysql.sock

    user=mysql

    # Disabling symbolic-links is recommended to prevent assorted security risks

    symbolic-links=0

     

    [mysqld_safe]

    log-error=/var/log/mysqld.log

    pid-file=/var/run/mysqld/mysqld.pid

     

     

    开机启动 MySQL

    chkconfig -add mysqld

     

     

    启动、停止 MySQL

    service mysqld start

    service mysqld stop

    service mysqld restart

    第一次启动会弹出

    [root@wood ~]# service mysqld start

    Initializing MySQL database:  Installing MySQL system tables...

    OK

    Filling help tables...

    OK

     

    To start mysqld at boot time you have to copy

    support-files/mysql.server to the right place for your system

     

    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

    To do so, start the server, then issue the following commands:

     

    /usr/bin/mysqladmin -u root password 'new-password'

    /usr/bin/mysqladmin -u root -h wood password 'new-password'

     

    Alternatively you can run:

    /usr/bin/mysql_secure_installation

     

    which will also give you the option of removing the test

    databases and anonymous user created by default.  This is

    strongly recommended for production servers.

     

    See the manual for more instructions.

     

    You can start the MySQL daemon with:

    cd /usr ; /usr/bin/mysqld_safe &

     

    You can test the MySQL daemon with mysql-test-run.pl

    cd /usr/mysql-test ; perl mysql-test-run.pl

     

    Please report any problems with the /usr/bin/mysqlbug script!

     

    设置管理员密码

    设置mysql管理员密码

    /usr/bin/mysqladmin -u root password 'new-password'

    /usr/bin/mysqladmin -u root -h localhost password 'new-password'

    配置mysql安装向导

    /usr/bin/mysql_secure_installation

    修改localhost,任何IP都可以远程访问mysql服务器
    更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改成"%" 
    mysql>use mysql; 
    mysql>update user set host = '%' where user = 'root'; 
    mysql>select host, user from user;
    mysql>FLUSH PRIVILEGES;

    为了安全,我是这样设置的

    话说IP怎么查?

  • 相关阅读:
    poplib
    【redis】哨兵模式
    no route to host
    修改文件失败,提示E509: 无法创建备份文件 (请加 ! 强制执行)
    【mysql】开启binlog后异常:impossible to write to binary log since BINLOG_FORMAT = STATEMENT
    rar
    manage.py命令
    zipfile
    【windows】git密码失效修改方式
    自动发现式推送数据,一次返回所有数据
  • 原文地址:https://www.cnblogs.com/wood-life/p/10307317.html
Copyright © 2020-2023  润新知