一、tcp/ip方式登陆

# /usr/local/mysql/bin/mysql -uwyc -p666 -h127.0.0.1 –P3306   //-h指定ip,-h后跟远程服务器ip,默认端口port是3306

二、socket方式登陆

# /usr/local/mysql/bin/mysql -uwyc -S /tmp/mysql.sock -p666

# /usr/local/mysql/bin/mysql –uroot –h127.0.0.1    //默认mysql用户密码为空

# /usr/local/mysql/bin/mysqladmin –uroot password ‘666777’ //设置密码

# /usr/local/mysql/bin/mysqladmin –uroot –p666777 password ‘778899’ //修改root用户密码

# vim /etc/profile.d/path.sh   //设置PATH

加入： export PATH=$PATH:/usr/local/mysql/bin

# source /etc/profile.d/path.sh    //执行path.sh