Tag: wordpress

  • How to reset wordpress user password using mysql

    login to the mysql #mysql -u -p /*use wordpress site database*/ mysql> show databases; mysql>use ; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed /*show database tables */ mysql>show tables; /*show users list */ mysql> SELECT ID, user_login,…

  • Setting up FTP Server for WordPress in Centos

    Setting up FTP Server for WordPress in Centos. STEP-1 Install Software Dependencies: [mp@web-srv1 ~]$sudo yum install vsftpd ftp -y [mp@web-srv1 ~]$yum install gcc php-devel php-pear libssh2 libssh2-devel make –y STEP-2  FTP Server Setup: #Make changes in /etc/vsftpd/vsftpd.conf and Uncomment following Lines anonymous_enable=NO ascii_upload_enable=YES ascii_download_enable=YES chroot_local_user=YES [mp@web-srv1 ~]$sudo /etc/init.d/vsftpd start [mp@web-srv1 ~]$chkconfig vsftpd on STEP-3 User…

  • Database migration in wordpress

    Database migration of wp sites in four steps using command line Assumption: mysql username: root mysql password: root Step-1: Backing up data base form old site: mysqldump -u[database_username] -p[database_password] [database_name] > [path][database_name.sql] Example: #mysqldump -uroot -proot wp_db >  /root/wp_db.sql Step-2: File Transfer Transfer  wp_db.sql file to server. Step-3: Create/Restore database #mysql -uroot -proot mysql>create database…