#16
  1. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Grant table installation errors


    Trybing to build into Irix6.5.1, with apache_1.3.11 and php4-b4p1 and keep on getting errors.

    Code:
    Creating columns_priv table
    000222 10:05:03  Can't create interrupt-thread (error 1, errno: 1)
    Installation of grant tables failed!
    Does anyone know of any reason why this would happen, I have tried the MySQL developers already but they dont know about Irix.
  2. #17
  3. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)
    I got this error granting column-level access.
    ERROR 1062: Duplicate entry 'remote.client-remoteuser-db-table-field' for key 1

    while the columns_priv table is empty and there is no integrity fault on the table.
    If there exists a duplicate on the key, OPTIMIZE TABLE would have complaind.

    Code:
    mysql> select * from mysql.columns_priv;
    Empty set (0.00 sec)
    
    mysql> optimize table mytable;
    Query OK, 7075 rows affected (1.13 sec)
    Records: 7075  Duplicates: 0  Warnings: 0
    in some cases
    I get
    ERROR 1030: Got error 22 from table handler

  4. #18
  5. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: System table was damaged.


    I found my system table for granting access was corrupted.<br>
    I installed the system again with the script; <code>mysql_install_db</code><br>
  6. #19
  7. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Question


    hello

    I try to connect me with Myadmin on my basic server data Mysql, it says to me that my host is not to authorize to however reach the host it is well recognized in the table host

    Thank you for your assistance
  8. #20
  9. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Question on access for database


    hello

    I try to connect me with Myadmin on my basic server data Mysql, it says to me that my host is not to authorize to however reach the host it is well recognized in the table host

    Thank you for your assistance
  10. #21
  11. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Can't Access Grant Table


    I have the same problem: can't access the GRANT table. Should I just run my scripts using the username/password I have?
  12. #22
  13. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    ISP with Root Access?


    Anyone know where I can find an ISP that allows root user access to MySQL?
  14. #23
  15. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    help!!!


    i am new about mysql, could somebody tell me how can i add a new user???


    Thanks
  16. #24
  17. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    how to create a table


    I am a php beginer.I wanna know how I can
    <br>
    create a table with sql scripts.
    <br>
    I have install mysql in windows NT.But I can't create any one table.
    <br>
    <br>
    I am very ......
  18. #25
  19. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Linux server / NT client


    This is a problem solved by a new MySQL user. It took me a couple of days and I'd like to share the problem and solution with others who might need it.

    My environment is MySQL installed on a Linux computer (Red Hat 6.2). I used KMySqlAdmin to modify the mysql database and mysqlaccess to check the results of my changes. This machine is networked to a Windows NT 4.0 machine, running Delphi 5 with the TmySql application dated 3/16/99. I tested my setup with the TmySqlClient Test Application.

    The problem was to be able to access MySQL on Linux from a Delphi application running on Windows NT.

    The solution is that the db and user tables (in the mysql database) must have a Host value of '%'. The User may be blank, but it may not be '%' or 'nobody'. In the db table, the db may be blank to apply to all tables or specified to apply to one table. If you have both, the specific table entry overrides the blank table entry. On the client, the hostname must specify the actual IP address of the Linux machine, not a DNS or 'Localhost'.

    I hope this helps someone.

    I'm thankful for those who have made this software available to us.
  20. #26
  21. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: Grant table does not work


    Yip, it worked. Selecting from user table shows host = '%' for my user I am having problems with. Changed this to localhost, and all is well, can connect do DB now. (thanx to rdj)

  22. #27
  23. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Access denied for user root???????


    I have tryed the following two commands.
    <br>
    <code>
    <br>
    GRANT ALL ON *.* TO 'test_user'@'%' IDENTIFIED BY "test"
    <br>
    GRANT ALL ON *.* TO 'test_user'@localhost IDENTIFIED BY "test"
    <br>
    </code>
    <br>
    I have tryed with and with out the ''s around the username. and for some reason all i ever get is this.
    <br>
    <code>
    <br>
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
    <br>
    </code>
    <br>
    It seams a bit strange to me that root cant create a user. i checked the user table in the mysql directory and everthing looks fine there as far as roots permissions to create new users. But it still wont let me create a new user. I managed to get a user inserted the hard way into the user table.
    <br>
    But it wont let me login using that user. so i probably did something wrong.
    <br>
    <br>
    mysql version 3.23.23-beta-debug OS win2k
    <br>
    <br>
    Am i missing something here? yes i tryed to reload the grant tables didnt apear to do anything.
    <br>
    <br>
    Any help would be greatly appreciated.
    <br>
    <br>
    kill-9
  24. #28
  25. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    can't connect


    I'm can't to MySql Server. When me connect to Mysql Server By Delphi and use MyODBC Or Telnet to Server and port 3306 the Server Reply to "is not allow to connect This MySql Server". HOW I Can do ?
  26. #29
  27. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Newbie Q - Getting mysqladmin access


    Hi

    Sorry to post what I think must be a simple question.

    I just installed Mysql on a Raq4 and everything went well. I changed the mysqladmin password as instructed. I can not logon as 'mysqladmin' . I am assuming that I have to use that logon to create databases as when I just login and get the mysql> prmopt it will not let me create a database.

    If you coudl help I would be very gratefull.

    Adam
  28. #30
  29. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    How can i create a user


    I wan to create a user in mysql a give it all rights i know is somenthing like create user...

    Can somebody tell me how is exactly the sql to do that

IMN logo majestic logo threadwatch logo seochat tools logo