How to install vsftp on CentOS 6.5

ftp

ftp

The File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files from one host to another host over a TCP-based network, such as the Internet. FTP is built on a client-server architecture and uses separate control and data connections between the client and the server.

This tutorial shows you how to install and configure FTP server in CentOS 6.5.

Before proceed,…

View On WordPress

ftp install linux vsftpd

How to create a new MySQL user and grant all privileges

mysql-lock

mysql-lock

Let’s start by making a new user within the MySQL shell:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Sadly, at this point newuser has no permissions to do anything with the databases. In fact, if newuser even tries to login (with the password, password), they will not be able to reach the MySQL shell.

Therefore, the first thing to do is to provide the user with access to the…

View On WordPress

centos linux mysql root

How to create a Wordpress Database using MySQL client

wordpress-logo-stacked-rgb

wordpress-logo-stacked-rgb

You can create MySQL users and databases quickly and easily by running mysql from the shell. The syntax is shown below and the dollar sign is the command prompt:

$ mysql -u adminusername -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5340 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE…

View On WordPress

bash centos database linux mysql wordpress

How to install MySQL on CentOS 6.5 with yum

mysql

MySQL is an open-source relational database. For those unfamiliar with these terms, a database is where an application keeps its data, and relational refers to how the data is organized and accessed within the database. SQL refers to the language used by application queries to retrieve and store data: Structured Query Language.

MySQL is free and widely used, meaning that you can find a large…

View On WordPress

centos install linux mysql yum