1. 登录mysql
mysql -u root -p
2. 查询哪些用户可以登录mysql
mysql> select host,user from user;
3. change column name(oracle好像不能change column name)
alter table [test] change [old_column_name] [new_column_name] tinytext;
4. 修改权限
mysql> flush privileges;
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10897379/viewspace-1017019/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量26
-
访问量174263
最新文章
- ORA-03117: two-task save area overflow
- Linux远程桌面到Windows
- ORA-00257: archiver error. Connect internal only, until freed
- sql优化
- Solaris: /home不可写
- ORA-01594: attempt to wrap into rollback segment (7) extent (2) which is being freed
- 我遇到的ORA-600错误
- Index on partition table
- Veritas volume manager
- ORA-30496: argument should be a constant.
