Half of Facebook users use mobile

The social stats platform SocialBackers shared some insights into how many people use Facebook via their mobile version and their mobile apps… the number is (not) suprising at all… it’s 543 million users, almost 57% of the total number of users.



The research shows that the highest number of mobile visits come from an Android based phones, while the iOS based iPhone and iPad make total of 25% (19% iPhone and 6% iPad).



North Americans are the most frequent mobile users on this social network, 161,7 million users from this continent like and share content daily on Facebook through their mobile devices.



On second place is Asia with around 134,2 million users and third in number of visits is Europe with 120,7 million

Create a MySQL Database, Username, Password, and Privileges from the command line

 

Step 1: Login to MySQL ( you will need an account )

user@server:~$ mysql -u mysql_user -p
Enter password:

 

tep 2: Create the Database

mysql > create database db_name;

 

Step 3: Verify that it’s there

mysql > show databases;




Step 4: Create the User

mysql > create user db_user;

 

Step 5: Grant privileges while assigning the password

mysql > grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';

*Note: The localhost field usually doesn’t have to be edited, but you can set it to the specific address.

The above example grants all privileges, obviously. But you will likely want to limit privileges under many circumstances. These parameters include select, insert, and delete.

Choose all that apply and separate by comma, thusly:

mysql > grant select, insert, delete on db_name.* to 'db_user'@'localhost' identified by 'db_password';