I had installed mysql and created my own database etc.
but then i had trouble connecting to it, so i looked at the privileges, and they seemed to ok, but it wouldnt connect!
Then some of the databases that come along with mysql disappeared and i only had \'mysql\' and \'test\' showing in \'mysqladmin\'.
I thought there was something wrong so i\'ve installed mysql again.
What i want to know is whether mysql only comes along with the two databases i.e \'mysql\' and \'test\' as i had two others before one of them which was \'library\'.
Will mysql work fine when i create my own database with \'mysql\' and \'test\' that comes along with it, or does it come along with anyother databases that you need inorder for it to work?
PLEASE PLEASE SOMEONE CLARIFY THIS FOR ME, AS IM CONFUSED!!!
The last thing i wanted to know was, as i have installed mysql how do i ensure that i am the root user? or grant myself all the privileges?? So that i am able to connect to it! do i need to assign myself the privileges first before i create my own database or can it also be done after?
I had this as a major problem before and i tried using the following:
GRANT ALL ON <mydatabase>.*TO ODBC@localhost IDENTIFIED BY <\"password\">
among other commands similar to this but it didnt work, and still wouldnt let me connect.