Thanks Matt - very helpful!
Not much in either the mqsql-slow.log or the mysql.err log however below is the mysql.log which does have something.
i’m trying to create a user named "jeff" (i’m logged in as "signcarver") - "jeff" doesn’t show up anywhere in the log file.
Do you see anything wrong below?
C:\xampp\mysql\bin\mysqld.exe, Version: 5.1.41-log (Source distribution). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
100923 19:26:23 1 Connect root@localhost on
1 Init DB atlalum
1 Query SET NAMES utf8
1 Query SELECT setting_name, setting_value FROM `atlalum`.`atlalum_user_settings` WHERE user=1
1 Query REPLACE INTO `atlalum`.`atlalum_active_users` (internalKey, username, lasthit, action, id, ip)
VALUES (1, 'signcarver', '1285284383', '75', NULL, '::1')
1 Query SELECT
mu.id,
mu.username,
rname.name AS role,
mua.fullname,
mua.email,
IF(mua.gender=1,'Male',IF(mua.gender=2,'Female','-')) AS gender,
IF(mua.blocked,'Yes','-') as blocked FROM `atlalum`.`atlalum_manager_users` AS mu INNER JOIN `atlalum`.`atlalum_user_attributes` AS mua ON mua.internalKey=mu.id LEFT JOIN `atlalum`.`atlalum_user_roles` AS rname ON mua.role=rname.id ORDER BY username
2 Connect root@localhost on
2 Init DB atlalum
2 Query SET NAMES utf8
2 Query INSERT INTO `atlalum`.`atlalum_manager_log`
(timestamp, internalKey, username, action, itemid, itemname, message) VALUES
('1285284383',
'1',
'signcarver',
'75',
'-',
'-',
'User/ role management')
1 Quit
2 Quit
3 Connect root@localhost on
3 Init DB atlalum
3 Query SET NAMES utf8
3 Query SELECT setting_name, setting_value FROM `atlalum`.`atlalum_user_settings` WHERE user=1
4 Connect root@localhost on
4 Init DB atlalum
4 Query SET NAMES utf8
4 Query SELECT count(*) FROM `atlalum`.`atlalum_user_messages` where recipient=1 and messageread=0
4 Query SELECT count(*) FROM `atlalum`.`atlalum_user_messages` where recipient=1
3 Quit
4 Quit
100923 19:26:25 5 Connect root@localhost on
5 Init DB atlalum
5 Query SET NAMES utf8
5 Query SELECT setting_name, setting_value FROM `atlalum`.`atlalum_user_settings` WHERE user=1
5 Query REPLACE INTO `atlalum`.`atlalum_active_users` (internalKey, username, lasthit, action, id, ip)
VALUES (1, 'signcarver', '1285284385', '11', NULL, '::1')
5 Query SELECT internalKey, username FROM `atlalum`.`atlalum_active_users` WHERE `atlalum`.`atlalum_active_users`.action=12 AND `atlalum`.`atlalum_active_users`.id=0
5 Query select name, id from `atlalum`.`atlalum_user_roles`
5 Query SELECT name, id FROM `atlalum`.`atlalum_membergroup_names` ORDER BY name
6 Connect root@localhost on
6 Init DB atlalum
6 Query SET NAMES utf8
6 Query INSERT INTO `atlalum`.`atlalum_manager_log`
(timestamp, internalKey, username, action, itemid, itemname, message) VALUES
('1285284385',
'1',
'signcarver',
'11',
'-',
