mysql permission settings question

From: Ernest (leucoplast_at_seanet.NOSPAM.com)
Date: 12/29/03 

Date: Mon, 29 Dec 2003 22:02:54 GMT

Note: I'm a mysql newbie.

I've installed mysql on Suse 9.0 using Yast. After the install, I was
getting permission errors when I tried to run mysql_install_db. So I
changed the permissions on /var/lib/mysql and /usr/share/mysql (and all of
their contents) so that everyone has full access to those directories. I
know that it's not secure but I just wanted to get the server to run.

After giving everyone full access to those directories, mysql_install_db and
mysqld_safe ran correctly, the mysql server starts, and I can run
phpmyadmin.

Now, of course, I want to secure the server and databases again but I have
no idea what the best settings for those directories/files/subdirectories
should be.

Also, when I run mysqld_safe -u mysql at the shell prompt, the server starts
but the linux: prompt doesn't come back. There is just a blank line that I
can type on but nothing that I type has an effect. What should I do at this
blank line?

Any help with this stuff will be greatly appreciated.

Thanks.

Relevant Pages

  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • [UNIX] phpMyAdmin PHP Code Injection (left.php)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... phpMyAdmin is "web-based MySQL ... does not prevent a malicious user from altering the servers configuration ... server configurations to the list of servers configuration by adding ...
    (Securiteam)
  • Re: Using MySQL as the backend
    ... I need to learn MySQL, ... > the impression you're not familiar with the concept of a server DB. ... > doesn't need to have Access installed to access the database, ... >> install the server or maybe I have it installed but I just don't know how to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: mySQL and ASP, ASP.NET and FP server extension
    ... If you're hosted on a Windows server, you can use MS Access, which is free, ... >>> Indeed, I was not thinking mySQL before, because Windows-based platform ... >>> usually comes with MS SQL and ASP and so on. ...
    (microsoft.public.frontpage.programming)