linux问题总结_MySQL

cd /etc/sysconfig

vi i18n

将LANG=en_US.UTF-8

改成LANG=zh_CN.gb2312

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

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

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

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

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

mysql> flush privileges;

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

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

# 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

groupadd mysql

useradd -g mysql mysql

cd /usr/local

gunzip

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

# 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