Web Analytics Made Easy -
StatCounter Permission problem (Linux + MySSQL) - CodingForum

Announcement

Collapse
No announcement yet.

Permission problem (Linux + MySSQL)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Permission problem (Linux + MySSQL)

    I installed MySQL and trying to get it working for few days, it wasn't easy. I am so massed up now it's not even funny, here is what I did.

    [[email protected] mysql]# mysqladmin -u root --password=<pass>
    it just gave me the mysqladmin help page

    [[email protected] mysql]# mysql -u root
    ERROR 1045: Access denied for user: '[email protected]' (Using password: NO)

    [[email protected] mysql]# mysql -u mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 47 to server version: 4.0.17-standard

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

    mysql> CREATE DATABASE HELLO_WORLD;
    ERROR 1044: Access denied for user: '@localhost' to database 'HELLO_WORLD'
    mysql>

    I use mysql with PHP, it was so easy, but when comes to command line, I don't know how it works.. From the above errors, can anyone tell me where I went wrong?

  • #2
    check here http://www.mysql.com/articles/ddws/4.html fot the installation and pre-installation tasks
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

    Comment


    • #3
      raf, thank you for your reply.

      PHP and MySQL is easy. I just don't know how to use mysql on Linux Command line.

      I don't know how to set up permission and stuff, I also don't understand www.mysql.com's documentation.

      I am new to this, If you had installed mysql on linux and use command line query, please help me

      thank you

      Comment


      • #4
        Originally posted by weronpc
        I just don't know how to use mysql on Linux Command line.
        I don't know how to set up permission and stuff, I also don't understand www.mysql.com's documentation.
        The link i posted contains some general commandline syntax.

        I don't know what sort of help you want. You just need to read up on that article and on some of the other that are available at mysql.com

        The mysql.com manual is also quite good so i don't quite see what you don't understand about it.
        Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

        Comment

        Working...
        X