Hello,
I bought MySQL by O'reilly. This thing is just as tough to read as the
manual but I am trying and utilizing both. When we installed MySQL on
our server, it seems to already be running. I was able to create a
database and everything so I assume that it is running. The book says
to run mysql in safe mode because it would restart the mysql server
automatically if it goes down. Does everyone out there use safe_mysqld
when running their servers? Do I need to stop the current server and
restart it as safe_mysqld? That is the part I am most confused by, what
to do now that I had already started it regularly. If anyone can help,
that would be great.
Also, if you just create a table as root and do not do anything with
security and permissions, would a perl program written on any domain
name on that server be allowed to access the database, or do I need to
give special permission to that domain name. I am curious if I just
give a host, "www.test.com", full access. I just get confused between
the host and the user. Is the user just the name being used to log in
to host? If so, when someone just executes the perl script from a call
from the browser, do I have to specify any specific permissions there.
They will not be running the script as the user I specify. I have read
about the wildcard "%" option but that seems a little unsafe.
Any help would be appreciated. I did my research before asking!
Thanks.
Isn't there a sample program out there that is simple, and quick that
you could create a database and test your interface to make sure that
you can start hacking away at some MySQL queries? This book has some
and they are huge with no CD.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
