Skip to main content

Database Issues

1. root user can grant privileges to other user so you need to login as

mysql -u , before granting privileges ...

GRANT ALL PRIVILEGES ON database.* to cruncher@localhost identified by "password"

2. create database IF NOT EXISTS indiagATpincampaignsDOTcom ;
ERROR 1044 (42000): Access denied for user 'cruncher'@'localhost' to database 'indiagDOTcom'

Reason : I did ...
" grant all privileges on *.* to cruncher identified by "password" ; "
instead of
grant all privileges on *.* to cruncher@localhost identified by "password" ;

Comments

Popular posts from this blog

Backslash on mac

I had been struggling to type back slash ( \) character on mac japanese keyboard as they don't have it printed on the keyboard, and I was doing copy paste all the time from google when i needed to type it until recently a tip came to my rescue , shortcut to backslash on mac japanese keyboard. Alt + ¥  Hope it helps others.