mysql别名
来源:互联网 发布:新淘宝网 编辑:程序博客网 时间:2024/05/01 18:03
mysql别名
[root@orcl~]# alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
[root@orcl~]# mysql
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 389055
Server version: 5.6.12-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
为了永久生效,需要在ssh用户/root/.bash_profile加载,因为我这边都是root帐号登录的
[root@orcl~]# more /root/.bash_profile
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/bin
alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
export PATH
[root@orcl~]#
[root@orcl~]# alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
[root@orcl~]# mysql
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 389055
Server version: 5.6.12-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
为了永久生效,需要在ssh用户/root/.bash_profile加载,因为我这边都是root帐号登录的
[root@orcl~]# more /root/.bash_profile
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
PATH=$PATH:$HOME/bin
alias mysql="/usr/local/mysql/bin/mysql -uroot --password="" -S /usr/local/mysql/mysql.sock";
export PATH
[root@orcl~]#
1 0
- mysql 别名
- mysql别名
- mysql别名问题
- 关于 mysql 别名问题
- MySQL别名的使用
- MySQL 之 别名语法
- mysql 别名delete
- MySQL Oracle 别名
- mysql中的别名resial
- mysql别名的使用
- MySQL的别名
- mysql 别名失效
- MySQL 表别名(Alias)
- hibernate sqlQuery mysql别名问题
- MYSQL delete语句不支持别名?
- jpa 操作mysql 别名问题
- MySQL学习笔记17:别名
- MySQL 查询表达式,别名
- [leetcode 300] Longest Increasing Subsequence
- 数据库DBO代码
- 为毛你深陷故障驱动式开发
- 一些可以使你感兴趣的c语言简单练习
- JS函数实现基本计算器计算
- mysql别名
- 唯爱小粽子:软件开发中前期准备的重要性
- 第5周项目3—时间类(2)
- cf17A Noldbach problem (素数打表)
- 安装lnmp后,忘记phpmyadmin的root密码,怎么办
- 面向切面编程(AOP)
- collection view 自定义
- RingtoneManager
- Python:文件操作