upgrade mysql 5.5 to 5.6 ubuntu 14.04

While MySql 5.5 is the default for Ubuntu 14.04, MySql 5.6 is available in the default repositories. It can be installed simply using:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.6

If you have existing data in a MySql 5.5 database, it should be migrated automatically. Though it is always a good idea to make a backup before doing a major upgrade.

First make a backup of the data in your existing database:

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql

Then after installing the newer version, you can restore if needed by running:

mysql -u root -p < dump.sql

For more info on migrating MySql databases, check out:

refrencia https://www.digitalocean.com/community/questions/upgrade-mysql-5-5-to-5-6-ubuntu-14-04

SQL Error(2013) Lost Connection: reading initial communication packet

SQL Error(2013) Lost Connection: reading initial communication packet

lost connection to mysql server at reading initial communication packet system error 0

My solution was to change the "bind-address" IP in the MySQL config file "/etc/mysql/my.cnf". It was set to the local IP of the server instead of "127.0.0.1" :-)

# bind-address            = 127.0.0.1
bind-address            = 162.243.235.246

Mi solución fue cambiar el "bind-address" IP en el fichero de configuración de MySQL "/etc/mysql/my.cnf". Se establece en la IP local del servidor en lugar de "127.0.0.1" :-)

# bind-address            = 127.0.0.1
bind-address            = 162.243.235.246

http://www.heidisql.com/forum.php?t=10835

http://www.bramschoenmakers.nl/en/node/595.html

How to Install PhpMyAdmin on CentOs 6.2 OR CENTOS 7

How to Install PhpMyAdmin on CentOs 6.2 OR CENTOS 7 

Step: 1 Create directory.
mkdir /download

Step: 2 Move into ‘/download’ directory.
cd /download

Step: 3 Download PhpMyAdmin installation source.

wget http://ufpr.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.3.8/phpMyAdmin-4.3.8-all-languages.tar.xz

Step: 4 Uncompressed downloaded file.
tar -xvf phpMyAdmin-4.3.8-all-languages.tar.xz

Step: 5 Move extracted files into ‘/var/www.html/phpmyadmin’
mv phpMyAdmin-4.3.8-all-languages  /var/www/html/phpmyadmin

Step: 6 Browse the below directory.
cd /var/www/html/phpmyadmin/

Step: 7 Create config file from sample configuration.

cp config.sample.inc.php config.inc.php

Step: 8 Edit config file.

vi config.inc.php

Step: 9  Change Authentication type.

Change Authentication type from cookie to http

save & exit

Step: 10 Restart Service

service httpd restart
OR
sudo systemctl restart httpd.service

now time to test phpmyadmin on webserver

http://104.236.206.80//phpmyadmin   – this is my server

It’s working fine..!!!

How To Set Up vsftpd on CentOS 6

About vsftpd

Warning: FTP is inherently insecure. If you must use FTP, consider securing your FTP connection with SSL/TLS. Otherwise, it is best to use SFTP, a secure alternative to FTP.

The first two letters of vsftpd stand for "very secure" and the program was built to have strongest protection against possible FTP vulnerabilities.

Step One—Install vsftpd

You can quickly install vsftpd on your virtual private server in the command line:

sudo yum install vsftpd

We also need to install the FTP client, so that we can connect to an FTP server:

sudo yum install ftp

Once the files finish downloading, vsftpd will be on your VPS. Generally speaking, the virtual private server is already configured with a reasonable amount of security. However, it does provide access to anonymous users.

Step Two—Configure VSFTP

Once VSFTP is installed, you can adjust the configuration.

Open up the configuration file:

sudo vi /etc/vsftpd/vsftpd.conf

One primary change you need to make is to change the Anonymous_enable to No:

anonymous_enable=NO

Prior to this change, vsftpd allowed anonymous, unidentified users to access the VPS's files. This is useful if you are seeking to distribute information widely, but may be considered a serious security issue in most other cases. After that, uncomment the local_enable option, changing it to yes.

local_enable=YES

Finish up by uncommenting command to chroot_local_user. When this line is set to Yes, all the local users will be jailed within their chroot and will be denied access to any other part of the server.

chroot_local_user=YES

Finish up by restarting vsftpd:

sudo service vsftpd restart

In order to ensure that vsftpd runs at boot, run chkconfig:

chkconfig vsftpd on

Step Three—Access the FTP server

Once you have installed the FTP server and configured it to your liking, you can now access it.

You can reach an FTP server in the browser by typing the domain name into the address bar and logging in with the appropriate ID. Keep in mind, you will only be able to access the user's home directory.

ftp://example.com

Alternatively, you can reach the FTP server through the command line by typing:

 ftp example.com

Then you can use the word, "exit," to get out of the FTP shell.