Lnmp环境搭建之mysql-5.5.49的安装配置_mysql-5.5.49离线安装-优快云博客

本文链接：https://blog.youkuaiyun.com/LDR1109/article/details/93723386
本文详细介绍了在Linux环境下从零开始搭建MySQL5.5数据库的过程，包括用户和目录创建、依赖安装、源码编译、配置文件调整、服务启动与管理等关键步骤，同时分享了解决常见问题的经验。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
==----------------------------------------------------------------------------------------------------------------------
-----== LINUX - mysql-5.5.49 搭建  参考：https://www.cnblogs.com/wolfboy55-163-com/p/8136050.html    【成功！！！】

1.添加mysql用户，创建mysql的数据目录：

    groupadd mysql

    mkdir -pv /mine/serve/mysql

    useradd -r -g mysql -d /mine/serve/mysql -s /sbin/nologin mysql

    chown -R mysql.mysql /mine/serve/mysql


2.安装cmake及依赖：

    yum install cmake gcc* ncurses-devel -y


3.下载MySQL安装包：

    cd /nine/software/mysql-5.5.49

    wget https://cdn.mysql.com//archives/mysql-5.5/mysql-5.5.49.tar.gz


4.编译安装MySQL：

    tar -xvf mysql-5.5.49.tar.gz

    cd mysql-5.5.49

    cmake -DCMAKE_INSTALL_PREFIX=/mine/serve/mysql -DDEFAULT_CHARSET=utf8 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/mine/serve/mysql/data -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DDEFAULT_COLLATION=utf8_general_ci

    make && make install

    #ln -s /usr/local/product/mysql5.5.49 /usr/local/mysql

    chown -R mysql.mysql /mine/serve/mysql


5.拷贝mysql的配置文件：

    cd /mine/serve/mysql/support-files/

    cp my-medium.cnf /mine/serve/mysql/my.cnf

    cp mysql.server /etc/init.d/mysqld

    chmod +x /etc/init.d/mysqld


6.初始化MySQL：

    cd /mine/serve/mysql/scripts

    ./mysql_install_db --user=mysql --basedir=/mine/serve/mysql/ --datadir=/mine/serve/mysql/data


7.修改MySQL配置文件my.cnf中数据目录（【mysqld】处添加）

    vim /mine/serve/mysql/my.cnf

    加入下面这句数据库的路径

    datadir=/mine/serve/mysql/data


8.启动MySQL：

    [root@zabbix ~]# /etc/init.d/mysqld start
    Starting MySQL..                                           [  OK  ]


9.把mysql加入系统服务项，并设置开机启动

    chkconfig --add mysqld

    chkconfig mysqld on

    service mysqld start


10.检查mysql是否成功启动

    ps aux |grep mysqld


11、进入mysql（相当于连接mysql）

    /mine/serve/mysql/bin/mysql  # 连着敲，不能断

    [root@iZm5eizpokikoertia0x31Z bin]# /mine/serve/mysql/bin/mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.5.49-log Source distribution

    Copyright (c) 2000, 2016, 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> select version();
    +------------+
    | version()  |
    +------------+
    | 5.5.49-log |
    +------------+
    1 row in set (0.00 sec)


12.创建一个hz2data数据库(分号不能漏）

    use mysql

    create database sdkdata;


13.创建一个mysql登录用户,用户名为：LDR 密码为 901198

    grant all on sdkdata.* to 'LDR'@'localhost' identified by '901198';


14.刷新权限

    flush privileges;


15、设置允许远程连接

    use mysql;

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '7668999' WITH GRANT OPTION;
    允许任何ip地址(%表示允许任何ip地址)的电脑用root帐户和密码(123456)来访问这个mysql server。

    注意admin账户不一定要存在。

16、后来，mysql服务连不上了，查看了一下
    [root@iZm5eizpokikoertia0x31Z ~]# /etc/init.d/mysqld start
    Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/iZm5eizpokikoertia0x31Z.pid).

    [root@iZm5eizpokikoertia0x31Z ~]# /mine/serve/mysql/bin/mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    有人说解决的办法是：
    1、编辑my.cnf文件
    [mysqld]
    basedir=/mine/serve/mysql/
    datadir=/mine/serve/mysql/data
    socket=/tmp/mysql.sock
    log-error = /mine/serve/mysql/data/mysql/error.log
    pid-file = /mine/serve/mysql/data/mysql/mysql.pid
    user = mysql
    tmpdir = /tmp

    2、重新初始化mysql
    ./mysql_install_db --user=mysql --basedir=/mine/serve/mysql --datadir=/mine/serve/mysql/data/mysql --pid-file = /mine/serve/mysql/data/mysql/mysql.pid --tmpdir=/tmp
    不行，我再编译：
    ./mysql_install_db --user=mysql --basedir=/mine/serve/mysql/ --datadir=/mine/serve/mysql/data --tmpdir=/tmp
    成功
    root@iZm5eizpokikoertia0x31Z scripts]# ./mysql_install_db --user=mysql --basedir=/mine/serve/mysql/ --datadir=/mine/serve/mysql/data --tmpdir=/tmp
    Installing MySQL system tables...
    190621 15:39:04 [Note] /mine/serve/mysql//bin/mysqld (mysqld 5.5.49-log) starting as process 8686 ...
    OK
    Filling help tables...
    190621 15:39:04 [Note] /mine/serve/mysql//bin/mysqld (mysqld 5.5.49-log) starting as process 8693 ...
    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:

    /mine/serve/mysql//bin/mysqladmin -u root password 'new-password'
    /mine/serve/mysql//bin/mysqladmin -u root -h iZm5eizpokikoertia0x31Z password 'new-password'

    Alternatively you can run:
    /mine/serve/mysql//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 /mine/serve/mysql/ ; /mine/serve/mysql//bin/mysqld_safe &

    You can test the MySQL daemon with mysql-test-run.pl
    cd /mine/serve/mysql//mysql-test ; perl mysql-test-run.pl

    Please report any problems at http://bugs.mysql.com/

    3、原始方法启动
    [root@iZm5eizpokikoertia0x31Z scripts]# /mine/serve/mysql/bin/mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    4、用新的吧
    [root@iZm5eizpokikoertia0x31Z scripts]# /etc/init.d/mysqld start
    Starting MySQL..                                           [  OK  ]

    启动了！

    参考：https://blog.51cto.com/fengyunshan911/2070818



-----== 76.55.24.689 aliyun的mysql远程连接不成功处理：

1、登录阿里云，进入控制台，找到对应的ecs服务器，在【操作】栏点-》【更多】-》【网络和安全组】-》【安全组配置】-》【配置规则】-》【添加安全组】
2、协议类型：MySQL(3306);授权对象：0.0.0.0/0;描述：mysql;其他默认即可。最后【确定】，就ok了！

参考：https://blog.youkuaiyun.com/u013225178/article/details/79403377

-------------------------------   https://www.cnblogs.com/wolfboy55-163-com/p/8136050.html
cmake -DCMAKE_INSTALL_PREFIX=/mine/serve/mysql -DDEFAULT_CHARSET=utf8 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/mine/serve/mysql/data -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DDEFAULT_COLLATION=utf8_general_ci

----------------------------------------------------------------------------------------------------------------------==