There are few ways you can create a new user for a MySQL DB. Using grant command to create a new user and assign privileges to access a DB. Use the create user mysql command followed by grant command to set access privileges. Directly editing the mysql DB using insert, update etc (which is a […]
Create a new MySQL user – Howto?
May 22nd, 2008Starting LAMPP automatically on startup
April 3rd, 2008For starting LAMPP automatically on startup, add the following line to you /etc/rc.local file /opt/lampp/lampp start where /opt/lampp is the location where XAMPP files are kept. You will have to substitute the path to your XAMPP in the above command. Do let me know whether it worked for you 😉
How to access mysql command mode in XAMPP
March 10th, 2008I had searched for some time for the same thing.. But here it is.. This is only in the case of a linux system.. Say your XAMPP files are at /opt/lampp On command line, type (assuming you want to log in as root) /opt/lampp/bin/mysql -u root -p This will be followed by typing the mysql […]
How to change root password in mysql ?
February 27th, 2008You might have installed mysql and would like to change / set password for root. Password for root might be empty initially.. So this is what you need to do. There is a mysqladmin command in unix,linux,freebsd to administer mysql. Setting root password for mysql for the first time Here the initial password is empty. […]
XAMPP an easy LAMP installation solution
February 25th, 2008Earlier I had messed up my LAMP test server trying to upgrade PHP from 4 to 5 and it was a real headache till I got everything to work.. Someone asked me a question – is there a simple way to install everything (Apache, MySQL PHP with necessary modules) in one shot without configuring each […]
Fatal error: Call to undefined function mysql_connect() !!
February 13th, 2008I was about to start using my first program on PHP5, then I received this irritating message. I was using PHP4 these days, so this error was something which revisited after a long time. In PHP4 I new what it means and how to rectify. The error indicates that PHP was unable to connect to […]
MySQL Storage Engines.. Some basics
December 13th, 2007Storage engines decide how and where the data is stored and in which way. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables MySQL supports following storage engines. MyISAM Storage Engine InnoDB Storage Engine MERGE Storage Engine MEMORY (HEAP) Storage Engine BDB (BerkeleyDB) Storage Engine EXAMPLE Storage Engine […]