

GRANT ALL PRIVILEGES ON dr_shilpi_log_activities.* TO 'root'@'192.168.29.%';

-- 3. Grant global privileges if needed
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.29.%' WITH GRANT OPTION;

-- 4. Flush privileges to apply changes
FLUSH PRIVILEGES;

-- 5. Verify the user was created
SELECT User, Host FROM mysql.user WHERE User = 'root';

-- 6. Test the connection (run from client machine)
-- mysql -h 192.168.29.101 -P 3309 -u root -p sb_pms
