OK,
I am just a bit confused still so I will try again. Do I need to stop mysql as it
is running now before I start safe_mysql or will it just replace the current
running version? Also, does it matter where I start it from? I can telnet to the
server, execute the command and then move on.
As far as database access is concerned. I have an admin person who would make
changes to the database. They would log in through the web but how do you know
where they are coming from to grant them special priviledges?
Also, when Joe Bob out there tries to execute the PERL script that accesses the
tables and executes queries, how am I supposed to grant them access to read
information? How would I know who Joe Bob is coming into the website? Do I just
grant the world read access to my database?
Sorry but I just don't quite understand this stuff yet.
Thanks.
Martin Stoufer wrote:
> 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.
>
> If you plan on using your db for some critical business service, I'd recommend
> running it in safe mode. This way, if and when it crashed, it would obviously
> restart. You can also tweak the startup script to notify you in some manner
> that it died and restarted.
>
> >
> >
> > 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.
>
> I had a bear with this as well; I know your pain! I found that if you make
> explicit enteries in the 'user' table of the 'mysql' db with password access
> from specific hosts, localhost as well, this goes a long way to lock people out
> from wreaking havoc with mySQL. Second, setup access for % from % with an
> encoded password (use the paswword() when you make the entry) in the user
> table. Also give them NO privileges of any kind. I'm pretty sure that this is
> the M.O. when a new entry is added. Once this is complete. Add individual
> entries into the db table for each user you want in and what db they are
> allowed to connect to. Tweak the individual privileges here. Once this is
> complete, do a [flush privileges] and you should be ready to go.
>
> Good luck!!
>
> -Martin
>
> >
> >
> > 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
