Mysql
lubinsu
我当前活着的每一天都是我余生最年轻的时候
展开
-
修改mysql编码格式
感谢:http://edge2009.iteye.com/blog/819466 1.查看mysql编码格式 show variables like 'character%'; 2.如果可以修改mysql.cnf文件(ubuntu在/etc/mysql/mysql.cnf) 找到客户端配置[client] 在下面添加 default-character-set=utf8 默认转载 2012-03-23 19:25:30 · 1501 阅读 · 0 评论 -
【MYSQL】修改密码
方法一mysqladmin -u root password "mysql"方法二SET PASSWORD FOR 'sqoop'@'%' = PASSWORD('sqoop');原创 2016-01-13 21:54:00 · 397 阅读 · 0 评论 -
【MySql】ERROR 1045 (28000): Access denied for user 'ambari'@'localhost' (using password: YES)
授权mysql> grant all privileges on *.* to ambari@'localhost' identified by 'bigdata'; Query OK, 0 rows affected (0.00 sec)刷新mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)原创 2016-01-13 21:55:40 · 4693 阅读 · 0 评论