MySQL :: Disable Table Name Case Sensitivity
Posted by blackonsole on April 5th, 2013 03:19 PM | No Comment
:: How to disable case sensitivity in MySQL
+ configure my.cnf file
Add this line in /etc/my.cnf in section:
+ Restarting mysqld
+ Testing
Those are command will show the tables record.
:: Links
+ Google
+ Burnayev
WordPress :: Add Admin User using MySQL Command Line
Posted by blackonsole on January 8th, 2013 02:06 AM | No Comment
:: How to add Admin User via MySQL Command Line
+ Login to mysql and select WordPress database
+ Show tables value to check user id
+ Add user admin level
+ Add user to wp_usermeta
+ Try login
open www.hostname.tld/wp-login.php and login using:
:: Links
+ Google
+ ...
cPanel :: MySQL server is currently offline
Posted by blackonsole on November 22nd, 2012 03:40 AM | No Comment
:: How to fix if you got "MySQL server is currently offline" in cPanel
just change mysql root password via WHM:
:: Links
+ Google
+ HostOutCast
CentOS:: Install and configure LAMP
Posted by blackonsole on July 16th, 2012 03:09 AM | No Comment
:: How to install LAMP on CentOS
:: How to configure MySQL
:: Add httpd and mysqld on init.d
:: Starting httpd and mysqld
:: Links
+ Google
+ HowToForge
:: MySQL : enable InnoDB from source
Posted by blackonsole on June 2nd, 2012 04:29 AM | No Comment
:: How to enable InnoDB on MySQL from source
:: Configure MySQL InnoDB on my.cnf
add / configure like these:
:: Restarting MySQL
:: Checking MySQL InnoDB
or
:: Links
+ Google
+ DevMySQL
+ DevReview