SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    What Does This MySQL Error Mean?

    After I login to the MySQL server as root, I am trying to create a new user by entering: "GRANT all ON *.* to john IDENTIFIED BY 'mypassword';" and it keeps coming up with this:

    ERROR 1146: Table 'mysql.user' doesn't exist

    I search Google and nothing came up. Does anybody know what this means or how I can create a user?


    John

  2. #2
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    does the mysql.user table exist? (ok stupid question but we've to eliminate that possibility first )

  3. #3
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK....I know this is a stupid question but I have to ask. How can I tell if it has been created? If it isn't created how can I make one?


    John

  4. #4
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Anybody?


    John

  5. #5
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    do this at your mysql command-line:
    Code:
    show databases;
    there has to be a mysql database listed (it's a 'system' database which mysql uses)
    then after you see that it exists, do this:
    Code:
    use mysql;
    show tables;
    there should be a 'user' table listed too

  6. #6
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello,

    I ended up just removing MySQL from my server so I could reinstall it. I just upgraded Apache to 1.3.26 yesterday which is running Red Hat Linux 7.2. I deleted the files in the /usr/local/mysql directory and whenever I run the configure it comes up with an error and I can't figure out how to get it to work. Here is what I've entered and the error that I'm getting after it runs for about 3 minutes:

    [root@username mysql-3.23.51]# ./configure --prefix=/usr/local/mysql --with-low-memory
    checking for fchmod... yes
    checking for getpass... yes
    checking for getpassphrase... no
    checking for initgroups... yes
    checking for mlockall... yes
    checking for fseeko... yes
    checking for dlopen... yes
    checking for dlerror... yes
    checking style of gethost* routines... other
    checking style of gethostname_r routines... glibc2
    checking 3 argument to gethostname_r routines... char
    checking "args to pthread_getspecific"... POSIX
    checking "args to pthread_mutex_init"... POSIX
    checking "args to readdir_r"... POSIX
    checking "style of sigwait"... POSIX
    checking "for pthread_attr_setscope"... yes
    checking "can netinet files be included"... "yes"
    checking "character sets"... default: latin1; compiled in: latin1
    checking for BerkeleyDB... no
    Not using Berkeley DB
    checking for Innodb... Not using Innodb
    checking for Gemini DB... Not using Gemini DB
    configure: creating ./config.status
    mkdir: cannot create directory `/tmp/cs19229-3476': No such file or directory
    : cannot create a temporary directory in /tmp


    Any ideas?


    John


Bookmarks

Posting Permissions

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