Tag:Install MySQL

  • The method of installing MySQL database in CentOS

    Time:2021-7-7

    1. First of all, download the installation file of MySQL. I’m installing version 5.1.7 of MySQL, 2. Install MySQL database server Enter the folder where the installation package is located, execute the command RPM – IVH MySQL server-5.1.7-0.i386.rpm to install MySQL server. If there is a conflict with the original version, execute the RPM – […]

  • The problem and solution of no prompt for password when installing MySQL in Ubuntu 18.04

    Time:2021-6-11

    The installation of MySQL 5.7 in Ubuntu 1804 is very detailed. Execute command to install MySQL sudo apt install mysql-server sudo apt install mysql-client After installation, check whether it starts sudo ps aux | grep mysql If it has been started, you can see the corresponding information after executing the above command. If it has […]

  • Install MySQL in Ubuntu to change the default password

    Time:2021-6-10

    Step 1: enter the directory: CD / etc / MySQL, and view the debian.cnf file Step 2: log in to MySQL using the account and password in the figure above. Step 3: view the library in the database. Step 4: use MySQL library. Step 5: use the following statement to set the account password:update user […]

  • CentOS installation of mysql8. X tutorial

    Time:2021-6-9

    MySQL installation (4,5,6 can be omitted) Statement: CentOS version is 7.6 and MySQL version is 8.0.17 1. First of all, you need to uninstall the MySQL related files, including MariaDB. RPM – PA | grep MySQL # will delete the search result with ‘RM – RF file name’, if not, skip it RPM – PA […]

  • Command details of installing mysql5.7 database under CentOS 7.2

    Time:2021-3-25

    MySQL server installed a version 8.0.12, the local version is a version 5.7, today removed the re installed version 5.7, the following is all the name of the command, follow will be installed. Configuration source wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm yum localinstall mysql57-community-release-el7-8.noarch.rpm # yum repolist enabled | grep “mysql.*-community.*” Installation: yum install mysql-community-server mysql start systemctl start […]

  • Installation of decompression version of MySQL under Windows 10

    Time:2021-1-2

    MySQL installation is divided into installation version and decompression version. The installation version is mainly installed by an EXE program with an interface and mouse click. Xiaobai recommends using the installation version to install mysql. Compared with the installation version, the decompression version is more “pure” and has no superfluous things, but it is more […]

  • How to install MySQL under Windows

    Time:2020-11-15

    1. Download installation package -Select the appropriate version according to your computer system: https://dev.mysql.com/downloads/mysql/ 2. Configure environment variables 2.1 decompress the downloaded package 2.2 environmental variables The win 10 computer goes in like this 3. Generate data file In the directory where you unzip it, eg: F: program files / mysql-8.0.17-winx64 / bin, and run […]

  • Linux CentOS 6.5 uninstall, tar install MySQL tutorial

    Time:2020-11-14

    Uninstall MySQL from the system 1. Check whether MySQL is currently installed in the system rpm -qa|grep -i mysql 2. Uninstall the current version of MySQL yum remove mysql mysql-server mysql-libs mysql-server Choose “Y” in the process of unloading Check again and no information indicates that it has been unloaded 3. Find the residual files […]

  • Install MySQL 8.0.17 and configure the method of remote access

    Time:2020-10-20

    1、 Preparation before installation View database version command:mysql –version mysql-community-common-8.0.17-1.el7.x86_64.rpm mysql-community-libs-8.0.17-1.el7.x86_64.rpm mysql-community-client-8.0.17-1.el7.x86_64.rpm mysql-community-server-8.0.17-1.el7.x86_64.rpm 2、 Install RPM package Install the above RPM packages in turn, and the former and the latter are dependent. # rpm -ivh mysql-community-common-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-libs-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-client-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-server-8.0.17-1.el7.x86_64.rpm 3、 Query the initial password of root […]

  • Complete tutorial for installing Apache, mysql, PHP, lamp on Ubuntu 18.04

    Time:2020-9-7

    1. Install Apache $ sudo apt update && sudo apt install apache2 There will be a pause in the middle, asking whether to continue, inputythenenter. 2. Test Apache Check that Apache is installed correctly by checking the status of the Apache service $ sudo service apache2 status After viewing the status, you need to press […]

  • MySQL installation notes for MySQL

    Time:2020-9-6

    1. Environmental preparation 1. MySQL installation path:/usr/local 2. CentOS 6.2 server (64 bit) 3. MySQL 5.7.28 download (64bit) wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz 2. MySQL installation 2.1 unzip and rename to MySQL 2.2 create the data directory under the MySQL directory 2.3 create MySQL user groups and users, and set user groups and users on MySQL directory 2.4 […]

  • How to install mysql8.0 in centos7.6

    Time:2020-8-30

    1. Generally, CentOS has MariaDB installed by default, so check whether to install MariaDB first. If so, you need to uninstall MariaDB first rpm -qa|grep mariadb rpm -e mariadb-libs –nodeps 2. Create the MySQL folder in the / usr / local / directory cd /cd usr/localmkdir mysql 3. Enter the MySQL folder and download mysql […]