- 博客(6)
- 资源 (6)
- 收藏
- 关注
原创 CentOS 6.4 change time zone
[root@CentOS Asia]# rm /etc/localtime rm: remove regular file `/etc/localtime'? y [root@CentOS Asia]# ln -s /usr/share/zoneinfo/Asia/Singapore /etc/localtime [root@CentOS Asia]# cat /etc/localtime TZi
2013-05-16 14:45:15 1266
原创 Change mysql default data location
move data location from /home/data/data to /usr/local/MySQL/data [root@CentOS mysql]# bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connect
2013-05-02 18:12:35 1375
原创 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 1640
原创 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 statement so check with the MySQL official document
2013-04-30 16:45:53 1280 1
原创 remove and re-install mysql 5.6 on centOS 6.4
[root@CentOS ~]# rpm -qa | grep -i mysql MySQL-client-5.6.11-1.linux_glibc2.5.x86_64 MySQL-server-5.6.11-1.linux_glibc2.5.x86_64 MySQL-devel-5.6.11-1.linux_glibc2.5.x86_64 [root@CentOS ~]# rpm -e MySQ
2013-04-29 13:33:34 4555
原创 SQL Server connect to MySQL
SQL Server connect to MySQL Step1: mysql testing db [demo], table [t];mysql server ip: [10.100.1.43] [root@centos ~]# mysql -h 10.100.1.43 -uroot -p Enter password: Welcome to the MySQL monitor.
2013-04-11 11:46:48 893
Pro SQL Server 2008 Reporting Services
2010-02-26
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人