Newb starting MySql-Permissions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • marko2
    #1

    Newb starting MySql-Permissions

    I have debian running and this is how I have it setup

    # ls -ld /var/lib/mysql
    drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql

    I was shown how to setup a password for user mysql here
    http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt,

    because at one time all I would have to do it hit enter after
    # mysql -h localhost -p -u mysql
    Enter password: (no password is added I just hit enter)
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 16 to server version: 4.0.14-log

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> ( can do whatever I want now???)


    If I type in the correct password it lets me in, if I type in no passowrd it
    lets me in, if I type in the INCORRECT password it does NOT let me in. How
    can I make it so that if no password is typed it still treats it as
    incorrect???


    Tags: None
    • marko2
      #2
      Re: Newb starting MySql-Permissions

      c# mysql -h localhost -p -u asdfasdf
      Enter password:
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 17 to server version: 4.0.14-log

      Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


      Also when I type just any username (asdfasdf) for the help of it and the hit
      enter as the password it still just lets me in.... Sorry if this is basic to
      some but the mysql.org site only deals with getting people connected not if
      they notice stuff like this.


        Comment

        • marko2
          #3
          Re: Newb starting MySql-Permissions

          c# mysql -h localhost -p -u asdfasdf
          Enter password:
          Welcome to the MySQL monitor. Commands end with ; or \g.
          Your MySQL connection id is 17 to server version: 4.0.14-log

          Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


          Also when I type just any username (asdfasdf) for the help of it and the hit
          enter as the password it still just lets me in.... Sorry if this is basic to
          some but the mysql.org site only deals with getting people connected not if
          they notice stuff like this.


            Comment

            Previous template Next
            Working...