hyrongg-CSDN博客

原创 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 1250

原创 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 1345

原创 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 1615

原创 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 1252 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 4531

原创 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 868