ALTER TABLE `TABLE_NAME` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `COLUMN_NAME_1` , `COLUMN_NAME_2` ) ;
ADD PRIMARY KEY ( `COLUMN_NAME_1` , `COLUMN_NAME_2` ) ;
XAMPP: Couldn't start MySQL! Trying to run mysql on ubuntu 10.10 and give this vauge error "XAMPP: Couldn't start MySQL!" Try this 1. Open a terminal. 2. run this command sudo chown -hR root /opt/lampp 3. then run this sudo chmod -R 777 /opt/lampp 4. Now Restart XAMPP sudo /opt/lampp/lampp restart U are all set. And if u r getting the follwing warning after restarting "Warning: World-writable config file ‘/opt/lampp/etc/my.cnf’ is ignored" 1.Open terminal 2.Migrate to /opt/lampp/etc 3.run the command sudo chmod 755 my.cnf
Comments