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

How to Use Chisanbop (Korean Finger Math) for Basic Addition and Counting | eHow.com

How to Use Chisanbop (Korean Finger Math) for Basic Addition and Counting eHow.com Difficulty: Easy Instructions Step 1 In Chisanbop you'll be using your two hands and ten fingers to represent numbers from 0 to 99. Start out with your hands out in front of you with closed fists. This represents 0. Each finger (not thumb) on your right hand represents 1. To represent 3, just press down three right hand fingers. Your right thumb represents 5. To represent 7, press down your right thumb and 2 right hand fingers. Think of your right hand as the ones or units place (column). Step 2 Your left hand represents the tens place (column). Each finger on your left hand is worth 10. For example, to represent 30, press down three left hand fingers. To represent 38, do the same, but also use your right hand to represent 8 as described above. Your left thumb represents 50. To represent 86, press down your left thumb and three left hand fingers for the 80, and your right thumb and one righ...

SQL, Report Generation Processs

Step 1. Export SQL result in to an csv file Step 2. Report Validation ( Through Excel ) ------------- The lifeline for any business intelligence solution is the process called extract, transform, and load (ETL). According to a recent survey by The Data Warehousing Institute (TDWI), ETL design and development work consumes 60 to 80 percent of the resources of an entire BI project. Selecting an ETL solution that fits your needs is an essential first step in building a successful data warehouse.