[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Can't Get MySQL running with IC
> is the interchange database user configured w/ INDEX capabilities, too?
> sounds to me like a database permissions problem. both the
> interchange user needs to be set up for that database, and given
> privleges on that MySQL server. what do your mysql.db and mysql.user
> tables look like?
I hope you can view these tables alright. I can at 1600 x 1200.
mysql.db
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| % | test | | Y | Y | Y |
Y | Y | Y | N | Y |
Y | Y |
| % | test\_% | | Y | Y | Y |
Y | Y | Y | N | Y |
Y | Y |
| localhost | cigar | bob | Y | Y | Y |
Y | Y | Y | Y | Y |
Y | Y |
| localhost | cigars | bob | Y | Y | Y |
Y | Y | Y | N | Y |
Y | Y |
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
4 rows in set (0.00 sec)
mysql.user
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| elide | root | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| localhost | | | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| elide | | | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| elide | zbert | 71de86b43b49a854 | Y | Y |
Y | Y | Y | Y | N |
N | N | N | N | N
| N | Y |
| localhost | zbert | 71de86b43b49a854 | Y | Y |
Y | Y | Y | Y | N |
N | N | N | N | N
| N | Y |
| localhost | bob | 1608e1316eb485af | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| localhost | interch | 29bad1457ee5e49e | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| % | interch | 29bad1457ee5e49e | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| localhost | matthew | 33bbae35660053bb | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| % | matthew | 33bbae35660053bb | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
11 rows in set (0.00 sec)
> and does it work using the DBA (eg, root user) username / password? no,
> this isn't an acceptable long-term solution, but might at least get you
> going.
I am able to perform just about anything I've thrown at MySQL while in
MySQL And when I run through makecat, the script appears to create the
db just fine. However, I end up with an empty database. No tables,
etc...
--Ralph
