Ubuntu :: Move datadir directory in MySQL
Posted by blackonsole on September 17th, 2013 01:09 PM | No Comment
:: What's MySQL
MySQL is open-source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.
:: How to move datadir MySQL directory in Linux Ubuntu
+ Stop mysqld
/etc/init.d/mysql stop
+ Move or copy mysql data ...
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
mysql -uroot -p
mysql>use db_wp;
+ Show tables value to check user id
mysql>select * from wp_users;
+ Add user admin level
mysql>insert into wp_users (ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name) values ('11','User Admin',MD5('AdminPassword','User ...
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:
WHM - SQL Services - MySQL Root Password - Change the password
:: 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
yum install httpd httpd-devel mysql mysql-server mysql-devel php php-mysql php-common php-gd php-mbstring php-mcrypt php-devel php-xml
:: How to configure MySQL
mysql_secure_installation
:: Add httpd and mysqld on init.d
chkconfig httpd on
chkconfig mysqld on
:: Starting httpd and mysqld
/etc/init.d/httpd start
/etc/init.d/mysqld ...
:: 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
cd mysql
./configure --prefix=/usr/local/mysql --with-plugins=innobase,innodb_plugin
make && make install
:: Configure MySQL InnoDB on my.cnf
vi /etc/my.cnf
add / configure like these:
default-storage-engine = InnoDB
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir ...
:: phpMyAdmin : Enabe / Disable Root Login
Posted by blackonsole on May 21st, 2012 03:15 AM | No Comment
:: How to enable root login in phpMyAdmin
vi config.inc.php
on /* Authentication type */ add this line:
$cfg = TRUE;
:: How to disable root login in phpMyAdmin
vi config.inc.php
on /* Authentication type */ add this line:
$cfg = FALSE;
:: Links
+ Google
+ MikeRoberto
:: MySQL: reset root password
Posted by blackonsole on April 29th, 2012 05:44 AM | No Comment
:: How to reset root password MySQL
+ stop mysqld
/etc/init.d/mysqld stop
+ starting mysql with skip grant table on background
mysqld_safe --skip-grant-tables &
+ login to mysql and reset password
mysql
use mysql;
update user set password=password('NEW_PASSWORD') where user='root';
quit;
+ kill mysqld
pkill -9 mysqld
+ starting mysql with new ...