当前位置:Gxlcms > mysql > linux问题总结_MySQL

linux问题总结_MySQL

时间:2021-07-01 10:21:17 帮助过:26人阅读

1.修改redhat enterprise5 语言

问题描述:切换语言

cd /etc/sysconfig

vi i18n

将LANG=en_US.UTF-8

改成LANG=zh_CN.gb2312

2.bash: ifconfig: command not found

问题描述:

切换到root用户下

[root@localhost /]$ ifconfig

依然提示:“bash: ifconfig: command not found”

whereis ifconfig 看一下这个命令在哪个目录下

方法一:[root@localhost sbin]$ /sbin/ifconfig 就可以出现使用了 方法二:[root@localhost sbin]$ export PATH=$PATH:/sbin 这样设置后,下次就可以直接访问了,免处第一种的麻烦

方法三:修改/etc/profile文件,注释掉if语句即可

把下面的if语句注释掉:

# Path manipulation

if [ "$EUID" = "0" ]; then

pathmunge /sbin

pathmunge /usr/sbin

pathmunge /usr/local/sbin

fi

修改为

# Path manipulation

# if [ "$EUID" = "0" ]; then

pathmunge /sbin

pathmunge /usr/sbin

pathmunge /usr/local/sbin

#fi

3. redhat linux开机就进入到命令行

vi /etc/inittab id:5:initdefault: 把这一句里面的5改成3就

4. redhat安装JDK失败

在 red hat enterprise linux5安装 jdk-7u21-linux-i586.tar.gz 时候出现下面的错误 :

Error: dl failure on line 864

Error: failed /home/jiangyang/jdk1.7.0_21/jre/lib/i386/client/libjvm.so, because /home/jiangyang/jdk1.7.0_21/jre/lib/i386/client/libjvm.so: cannot restore segment prot after reloc: Permission denied

解决方案:

chcon -t textrel_shlib_t $JAVA_HOME/jre/lib/i386/client/libjvm.so

5. 设置mysql远程连接root权限

mysql> Grant all privileges on *.* to'root'@'%' identified by '密码' with grant option;

(%表示是所有的外部机器,如果指定某一台机,就将%改为相应的机器名;‘root’则是指要使用的用户名,)

mysql> flush privileges;

(运行此句才生效,或者重启MySQL)

6. ubuntu 配置静态IP

root@ubuntu1:~# vi /etc/network/interfaces

# This file describes the network interfaces available on your system

# and how to activate them. For more information, see interfaces(5).

# The loopback network interface

auto lo

iface lo inet loopback

# The primary network interface

auto eth0

iface eth0 inet static

address 192.168.2.111

netmask 255.255.255.0

gateway 192.168.2.1

root@ubuntu1:~# /etc/init.d/networking restart

如果配置动态IP如下:

# This file describes the network interfaces available on your system

# and how to activate them. For more information, see interfaces(5).

# The loopback network interface

auto lo

iface lo inet loopback

# The primary network interface

auto eth0

iface eth0 inet dhcp

7Ubuntu 安装 chkconfig

在Ubuntu 中是没有chkconfig命令,通过安装chkconfig_11.0-79.1-2_all.deb来达到使用chkconfig命令的目的。

8.ubuntu mysql安装

安装mysql-6.0.7-alpha-linux-i686-glibc23.tar.gz 版本的linux。

groupadd mysql

useradd -g mysql mysql

cd /usr/local

gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -

ln -s full-path-to-mysql-VERSION-OS mysql

cd mysql

chown -R mysql .

chgrp -R mysql .

scripts/mysql_install_db --user=mysql

chown -R root .

chown -R mysql data

bin/mysqld_safe --user=mysql &

/usr/local/mysql/bin/mysqladmin -u root password ‘新密码’

cp support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/rc.d/init.d/mysql

chkconfig --add mysql

cp support-files/my-medium.cnf /etc/my.cnf

service mysql start

9. linux下的mysql乱码

在linux下中使用mysql的话可能会出现中午乱码的情况。通过查询mysql的编码集可以发现是使用的latin1需要修改。

修改/etc/my.cnf配置文件。

# The following options will be passed to all MySQL clients

[client]

#password = your_password

port = 3306

socket = /tmp/mysql.sock

default-character-set=utf8

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

port = 3306

socket = /tmp/mysql.sock

skip-locking

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

default-character-set=utf8

重启数据库后再次查看数据库的编码集信息。

/etc/init.d/mysql stop

/etc/init.d/mysql start

人气教程排行