No pictures shown, mysql problem?
Posted: Wed Mar 15, 2006 9:16 pm
Hi all!
I have just installed zoneminder in a fedora 3. Compiled and up and running but there is no pictures shown. Maybe it is something about the mysql because the pictures in the folder IMAGES are like 'core.6648' and 863MB large.
There is only root@myhost in user() in the database mysql. I have to admit mysql is not my profession at all. I may have messed up the registration of my user beo@localhost at the beginning. When i try this:
mysql> insert into user (Host,User,Password)
-> values('localhost','beo','YES');
ERROR 1062: Duplicate entry 'localhost-beo' for key 1
I also tried this:
mysql> insert into user (Host,User,Password)
-> values('%','beo',PASSWORD('YES'));
Query OK, 1 row affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
file:///home/beo/IVC/zoneminder_1.22.0/ZoneMinder-1.22.0/README.html
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
How can i remove all the mess i have made, like the databases and users and start all aver again?
I have just installed zoneminder in a fedora 3. Compiled and up and running but there is no pictures shown. Maybe it is something about the mysql because the pictures in the folder IMAGES are like 'core.6648' and 863MB large.
There is only root@myhost in user() in the database mysql. I have to admit mysql is not my profession at all. I may have messed up the registration of my user beo@localhost at the beginning. When i try this:
mysql> insert into user (Host,User,Password)
-> values('localhost','beo','YES');
ERROR 1062: Duplicate entry 'localhost-beo' for key 1
I also tried this:
mysql> insert into user (Host,User,Password)
-> values('%','beo',PASSWORD('YES'));
Query OK, 1 row affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
file:///home/beo/IVC/zoneminder_1.22.0/ZoneMinder-1.22.0/README.html
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
How can i remove all the mess i have made, like the databases and users and start all aver again?