Getting Next Existing Record in a DB
Wondered how to do it,, & did it Using offset: sql: SELECT * FROM foo WHERE id = 4 OFFSET 1
Posts
MySQL Change root Password
Source : http://www.cyberciti.biz/faq/mysql-change-root-password/ mysqladmin command to change root password If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows: $ mysqladmin -u root password NEWPASSWORD However, if you want to change (or update) a root password, then you need to use following command $ mysqladmin -u root -p'oldpassword' password newpass For example, If old password is abc, and set new password to 123456, enter: $ mysqladmin -u root -p'abc' password '123456' Change MySQL password for other user To change a normal user password you need to type (let us assume you would like to change password for vivek): $ mysqladmin -u vivek -p oldpassword password newpass Changing MySQL root user password using MySQL sql command This is another method. MySQL stores username and passwords in user t...
Connecting Db in ruby
MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB_NAME = 'localhost', 'root', '', 'artiklz_development' @@dbh = Mysql.real_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB_NAME)