Posts Tagged by mysql
How to grant privilege to database for particular user using unix
| December 2, 2011 | Posted by Subikar under linux, network, subikar |
Login to unix Croot@cyber-desktop:~# mysql mysql> GRANT ALL ON databasename.* TO username@’mysqlhost’ IDENTIFIED BY ‘databasepassword’; Thats all
Import and export big db in linux
| September 14, 2009 | Posted by Subikar under linux, phpmyadmin |
Here is my short blog post lets share with my friends who are learning linux and want to import or export data to phpmyadmin using linux. So here is the code for that. Data Export in linux mysqldump -u dbusername -h dbhost -pdbpassword dbname > dbname.sql Data Import in linux mysql -u dbusername -h dbhost…
Create New joomla password function
| April 27, 2009 | Posted by Subikar under cms, joomla, myblogplanner, subikar |
Let me show you how you can create joomla password function Here is the exmaple how you can create joomla 1.5.x password function. function FnGenerateNewPassword($Password) { jimport(‘joomla.user.helper’); $salt = JUserHelper::genRandomPassword(32); $crypt = JUserHelper::getCryptedPassword($Password, $salt); $password = $crypt.’:’.$salt; return $password; } Hope this will help you in some program.
