mysql 远程端口3306
以前使用远程登录oracle数据库的时候,发现随便一个客户端都能登录, 但是用mysql的时候发现登录不了, 我估计是远程登录3306 没有侦听?
进入mysql -uname -ppass
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root' @'%' IDENTIFIED BY 'koolma2010' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES
先记录下方法, 有时间在去研究
安装mysql linux
shell> groupadd mysql
0885shell> useradd -r -g mysql mysql
0886shell> cd /usr/local
0887shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
0888shell> ln -s full-path-to-mysql-VERSION-OS mysql
0889shell> cd mysql
0890shell> chown -R mysql .
0891shell> chgrp -R mysql .
sudo apt-get install libaio-dev
0892shell> scripts/mysql_install_db --user=mysql
0893shell> chown -R root .
0894shell> chown -R mysql data
0895shell> cp /usr/local/mysql/support-files/my-small/etc/my.cnf # Optiona
0896l
0897shell> bin/mysqld_safe --user=mysql &
0898shell> cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server # Optional
联想V460
ubuntu 无线网卡不能启用
uozhuang@luozhuang-V470:~$ sudo gedit /etc/modprobe.d/blacklist.conf
新开一行,输入如下内容:
blacklist acer_wmi