Web host sites
158 Part II . SQL Essentials Common CLI Errors Using the CLI myself (and working with many people who are new to databases and the CLI), I ve seen quite a few error messages. Often the errors crop up simply because I can t seem to type well that day, but just as often they show up for other reasons that call for some simple troubleshooting. Access Denied errors The Access Deniederror has a number of variations, three of which are shown in Figure 8-32. Figure 8-32: Three variations of the Access Denied error with the CLI Here s what produced the errors shown in Figure 8-32: . In the first example I am trying to obtain access to the CLI as the user suehring but I am not specifying a password via the -pswitch. This try fails; the error message hints (not too subtly) why: Using Password: No. . In the second attempt, I add the -p switch but then press Enter instead of typing the password. Notice the similarity of result between the second and first attempts (though I didn t use the -p switch in the first one). . In the third attempt, I use the -p switch but mistype the password. Notice this time that the end of the error message is different: Using Password: Yes. Another variation of the Access Denied error is shown in Figure 8-33: I try to connect to a database on which I have no privileges or rights. As you can see, the error number is different, as is the message.
Note: In case you are looking for affordable webhost to host and run your servlet application check Vision mysql5 web hosting services