Home » Posts filed under mysql
Installation Mysql, php, apache
My environment: OS Red Hat Enterprise Linux Server release 6.5 (Santiago) MySQL Version 5.1.73-community MySQL Community ...
How to fix Error Vietnamese font on Xampp
[Describe]: [FIXED] Step 1 : Open Xampp Control Panel, Click Config on MySQL Module Step 2: Open my.ini Step 3: Uncomment rows following a...
How to Compare two strings using stored procedure in Mysql
Compare two strings using stored procedure in Mysql Only need one (1) equals sign to evaluate DECLARE @tempo VARCHAR(20) SET @tempo ...
Split String with comma Loop in Mysql store Proceture Example
Hello Here Very Usefull for Split String with comma Loop in Mysql store Proceture Example Split String with comma Loop in Mysql store proce...
how to remove index and unique constraint in mysql
Hello here Example of remove how to remove index and unique constraint in mysql first check table how many constraint in table after you ca...
How to change MySQL datadir
Step 1 : Create new data folder for mysql (For example: /u01/mysql/data) [root@ptudvtg149 ~]# mkdir -p /u01/mysql/data Step 2 : Copy a...
MySQL - Resetting a lost MySQL root password
Not the Server root user A common issue is confusing the Server root user with the MySQL root user. The Server root user is the server'...
Chapter 4: Dumping Applications Manager's data to MySQL 5.1
Prerequisites: It's very important, you have to backup Applications Manager data before you execute this task. We recommended take com...
Chapter 2: Installing and Upgrading MySQL 5.0 to MySQL 5.1
Prerequisites: Check your OS' version: [root@poller1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5...