May 11, 2010

Mysql Queries in Linux

Linux General,

How to resolve mysql_connect() Error Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘username’@’localhost’ (using password: YES) Possible root cause for this problem is proper privilege not assigned to the particular user. So providing proper privileges will solve this issue. $grant all privileges on “Database_Name” to “username@localhost” identified by “password” If the mysql resides in the…

Read more
December 26, 2009

How to change the client prompt in MySQL?

Database,

Change MySQL’s prompt by using the prompt command: mysql>prompt mysql (\d)> Once executed, the currently selected database will appear in the prompt, like so: mysql (mydatabase)> It’s also easy to lose track of which database server you’re logged in to, not to mention which account you’re using. To fix this, modify your prompt using the…

Read more