复制mysql.server脚本到/etc/init.d(初始化服务)
sudo cp support-files/mysql.server /etc/init.d/mysql.server
查看mysql运行状态:
sudo service mysql.server status
启动关闭:
sudo service mysql.server start|stop
设在mysql开机启动:defaults开机启动,remove取消开机启动
sudo update-rc.d -f mysql.server defaults | [remove]
将mysql命令加入到命令中或者将mysql的bin目录加入环境变量
sudo ln -s bin/mysql /usr/local/bin/mysql
export PATH=$PATH:/opt/mysql5.6/bin
允许root用户远程登陆:
mysql -u root -p
全部主机登陆
grant all privileges on *.* to root@“%” identified by “111111” with grant option;
指定主机登陆
grant all privileges on *.* to root@“192.168.1.101” identified by “passw0rd” with grant option;
授权生效:flush privileges;
补充:装完workbench后忽然启动报错,参考一下解决
cp support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
vim mysql
#修改以下两个变量
basedir=/home/software/mysql-5.5.20
datadir=/home/software/mysql-5.5.20/data
然后执行 update-rc.d mysql defaults
#再使用service mysql start来尝试启动,报错:
#Couldn‘t find MySQL server (/usr/bin/mysqld_safe),路径不对,不应该到/usr/bin下寻找mysqld_safe,怀疑mysql启动时加载配置文件出错,mysql配置文件的读取顺序为:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
挨个查看,发现 /etc/mysql/my.cnf中的以上两个对应值不正确,修改后测试,发现可用service mysql start来启动mysql
4.mysql workbench
安装 mysql-workbench-community-6.0.6-1ubu1304-amd64.deb版本,简单省事。。.。
实践证实这是最Fuck的方法。。.。。.。。.具体看下文。。.。。.。。.。
5.eclipse javaee
解压:tar -xvf
移动到/opt目录:mv eclipse /opt
修改用户组和权限:
sudo chown -R root:root eclipse/
sudo chmod -R +r eclipse
sudo chmod +x `sudo find eclipse -type d`
建立可执行方式:
sudo touch /usr/bin/eclipse
sudo chmod 755 /usr/bin/eclipse
sudo vim /usr/bin/eclipse 加入如下:
#!/bin/sh
export ECLIPSE_HOME=“/opt/eclipse”
$ECLIPSE_HOME/eclipse $*
建立快捷启动方式:
sudo vim /usr/share/applications/eclipse.desktop 加入如下:
[Desktop Entry]
Encoding=UTF-8
Name=Eclipse
Comment=Eclipse IDE










