Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    8

    Unanswered: adding users to mySQL

    Hi

    I'm very much a beginner but keen to learn as much as I can about running a Linux based web server...so much so I'm renting my own VPS and trying to teach myself.

    I now have mySQL running successfully and I'm trying to configure it in respect of users and databases...essentially populating the database called "mysql".

    I came across this helpful article.

    http://www.linuxhelp.net/guides/mysql/

    However my question is ...is it really necessary to do all the mysqladmin commands......it just that other articles I've seen suggest don't mention it.

    Basically I just wanted to be sure either way first in case I messed anything up.

    Thanks very much.

  2. #2
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    I recommend that you have a look at the MySQL reference manual, section 5.5. Links to the manual: for MySQL 5.0 or MySQL 5.1.

  3. #3
    Join Date
    Jan 2008
    Location
    Kingdom of Sweden
    Posts
    11
    If you haven't done it already; you should run the mysql_secure_installation script that is shipped with MySQL. It will somewhat secure the installation (set a password for root, remove the test database, remove anonymous users etc.).

    When setting up new users, you really shouldn't start doing so manually (that is, manually inserting them into the grant tables). Use CREATE USER, GRANT and REVOKE instead.

    And I agree with snorp; Be sure to read the reference manual.

  4. #4
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    Quote Originally Posted by by0nder
    If you haven't done it already; you should run the mysql_secure_installation script that is shipped with MySQL. It will somewhat secure the installation (set a password for root, remove the test database, remove anonymous users etc.).
    Good point!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •