Why, if I have MySQL is the MySQLAdmin not on the box? Is
there something else I must install? I've downloaded the
rpm from the web site and installed. When it boots, MySQL
does come up and it says that it has started without
errors.
What am I missing?
Hey All!
Anyone know the difference between MySQL and PostgreSQL?
Are the both pretty much the same? So far I like MySQL, but
find that MS SQL is far greater, but only because it has
much more. Anyone have any comments on the matter?
-
Alright then!
> database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
I'm sorry if I'm bothering people, some times I get the
feeling that I am, so please let me know if I'm out of line.
So now I've figured out that I need to use the
skip-show-database option which I have added to the my.cnf
file under [mysqld]. When I do this now and log in using
MySQLGUI as a
I posted about this before and got nothing back so I guess I
should take it a step at a time.
I've granted a user ALL PRIVILEGES on a particular database
and when they log in using MySQLGUI they can see all the
databases on the server. Even though they can't do anything
with them, I would pre
I'm using the:
LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
which works just fine. Only problem is the date column
which is formatted as such "4/11/1970" comes out as "-
00-
00"
The date field is setup as Field: "s_date", Type: "date",
Null, "YES", Key: BLANK, Default: "Nul
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu they also see the other datab
I've downloaded and am trying to use the MySQLGUI as well
and had the same problem, but figured it had to me a
firewall problem so I opened up port 3306 in my IPchains
and it let me through only now it's telling me that the
computer I am coming from is not allowed to connect to
MySQL server.
