Set Hue uses UTF8 collation and character set

# To create (use utf8_general_ci or utf8mb4_general_ci): CREATE DATABASE hue COLLATE = ‘utf8_general_ci’; # To view default_character_set_name and default_collation_name SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; # To alter if not created with UTF8 collation ALTER DATABASE hue COLLATE = ‘utf8_general_ci’; mysql> CREATE DATABASE hue COLLATE = ‘utf8_general_ci’; ERROR 1007 (HY000): Can’t create database ‘hue’; database exists mysql>Continue reading “Set Hue uses UTF8 collation and character set”

Create Hue Database in Red Hat

Log on to MySQL with your root password: mysql -u root -p Enter password: Create a database for Hue (we call it “hue” but any name works) with UTF8 collation and grant user privileges: create database hue default character set utf8 default collate utf8_general_ci; grant all on hue.* to ‘hue’@’%’ identified by ‘huepassword’; select *Continue reading “Create Hue Database in Red Hat”

Start MySQL in RedHat Linux

To Start MySQL Server in RedHat Linux Server use following commands service mysqld start [root@server ~]# service mysqld start Initializing MySQL database: Installing MySQL system tables… OK Filling help tables… OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORDContinue reading “Start MySQL in RedHat Linux”

Install MySQL in RedHat

# yum install mysql-server [root@Server]# yum install mysql-server Loaded plugins: product-id, search-disabled-repos, security, subscription-manager Setting up Install Process Resolving Dependencies –> Running transaction check —> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be installed –> Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-server-5.1.73-8.el6_8.x86_64 –> Running transaction check —> Package mysql.x86_64 0:5.1.73-8.el6_8 will be installed –> Finished Dependency ResolutionContinue reading “Install MySQL in RedHat”