Insert Unicode Data Into MySQL Database in PHP

In order to insert unicode data into MySQL database, you will need to create tables using unicode support: mysql> set names ‘utf8′; mysql> create database test_database character set utf8 collate utf8_unicode_ci; mysql> use test_database; mysql> create table test_table (name varchar(255) character set utf8 collate utf8_unicode_ci); Now use PHP to insert …

Recover MySQL root password

You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password Step # 3: Connect to mysql server as the …

Install Apache 2, MySQL 5, PostgreSQL 8 and PHP 5 under Ubuntu Desktop

Ubuntu is a free, open source Linux-based operating system that starts with the breadth of Debian and adds regular releases (every six months), a clear focus on the user and usability (it should “Just Work”, TM) and a commitment to security updates with 18 months of support for every release …