How to add mysql system environment variables in Linux

Linux adds mysql system environment variable

After installing mysql yesterday, I added export PATH=/usr/local/ directly in the line above export PATH mysql/bin, and then found that all mysql commands can be used normally, I am very happy.

I was confused the next day. After the Linux system started, I was always logged in. After entering my account and password, I could not log out. After searching on the Internet, I found that the code I added damaged the profile file, causing the system to fail to start. Entering the command line mode can be achieved by pressing ctrl alt F2, and then you can log in successfully after modification.

So I still can’t modify the configuration according to the Windows method, I still need to check it.

When using source code to install software under Linux, you can usually only use the software command in the software installation directory (except for installation using the yum command). This is too troublesome. We hope to use it globally and install the software The path is added to the system environment variables.

There are two ways to add environment variables

//1,使用export命令
export PATH=$PATH:/opt/software/node-v8.9.3-linux-x64/bin/node

//export使用方法为 export PATH=$PATH:路径1:路径2:路径n;$PATH为系统变量,表示之前所有设置的路径，如果不加则之前所有的路径都失效。所以必须加上。

//2,修改配置文件/etc/profile
vi /etc/profile

在里面加入:export PATH=$PATH:/opt/software/node-v8.9.3-linux-x64/bin/node

//如果是修改用户主目录下的.bash_profile，则添加的环境变量只对该用户有效，修改/etc/profile对所有用户都生效。也可以修改/etc/rc.local文件和/root/.bashrc文件。
//修改好配置文件后执行source /etc/profile 或者 source /root/.bashrc使配置文件生效

After correcting the above problem, I found that the connection to mysql was blocked and there was a sock error.

It turns out that mysqlserver is closed, so you need to start mysqlserver.

• Give executable permissions chmod x /etc/init.d/mysqld

• Add service chkconfig --add mysqld

• Display service list chkconfig --list

If you see the mysqld service and 3, 4, and 5 are all "on/open", it will be successful. If it is off/closed, type:

chkconfig --level 345 mysqld on

Modify the mysql environment variable under linux

Find the mysql execution path under linux

eipdb2:~ # cd /eipdb2/mysql/bin/
eipdb2:/eipdb2/mysql/bin # pwd
/eipdb2/mysql/bin

Find /etc/profile

Add the environment variable at the end

export PATH=/eipdb2/mysql/bin:$PATH
"/etc/profile" 419L, 9839C

source profile to make the environment variable take effect

You can enter it in any directory in the future

mysql -uroot -p password

Login to mysql successfully

The above is the detailed content of How to add mysql system environment variables in Linux. For more information, please follow other related articles on the PHP Chinese website!