Yes stop the old and start the new...on a side note...should have bought
DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on
this sort of stuff. In any event safe_mysqld seems to be default on most
sytems...Yes please get you security straight...if the app is colocated on
the same server you can get away with localhost, however; if not then you
must make an entry for each domain...
Cheers,
Mikel
Carlos Corzo wrote:
> 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
---------------------------------------------------------------------
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