- 博客(6)
- 资源 (6)
- 收藏
- 关注
原创 CentOS 6.4 change time zone
[root@CentOS Asia]# rm /etc/localtimerm: remove regular file `/etc/localtime'? y[root@CentOS Asia]# ln -s /usr/share/zoneinfo/Asia/Singapore /etc/localtime[root@CentOS Asia]# cat /etc/localtimeTZi
2013-05-16 14:45:15 1258
原创 Change mysql default data location
move data location from /home/data/data to /usr/local/MySQL/data[root@CentOS mysql]# bin/mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connect
2013-05-02 18:12:35 1365
原创 install mysql 5.6 from binary on CentOS 6.4
[root@CentOS local]# groupadd mysql[root@CentOS local]# useradd -r -g mysql mysql[root@CentOS local]# cd /usr/local[root@CentOS local]# tar zxvf /usr/local/mysql-5.6.11-linux-glibc2.5-x86_64.tar.gz
2013-05-02 17:39:47 1630
原创 You must set password before executing this statement
Today I install the MySQL 5.6, when I login with the root, get an error message:ERROR 1820 (HY000): You must SET PASSWORD before executing this statementso check with the MySQL official document
2013-04-30 16:45:53 1273 1
原创 remove and re-install mysql 5.6 on centOS 6.4
[root@CentOS ~]# rpm -qa | grep -i mysqlMySQL-client-5.6.11-1.linux_glibc2.5.x86_64MySQL-server-5.6.11-1.linux_glibc2.5.x86_64MySQL-devel-5.6.11-1.linux_glibc2.5.x86_64[root@CentOS ~]# rpm -e MySQ
2013-04-29 13:33:34 4546
原创 SQL Server connect to MySQL
SQL Server connect to MySQLStep1: mysql testing db [demo], table [t];mysql server ip: [10.100.1.43][root@centos ~]# mysql -h 10.100.1.43 -uroot -pEnter password:Welcome to the MySQL monitor.
2013-04-11 11:46:48 887
Pro SQL Server 2008 Reporting Services
2010-02-26
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人