Tag: root

MySQL

Reset Root Password for MySQL user in Windows

1. Stop MySQL service. Run services.msc as administrator and stop it. 2. Run cmd.exe as administrator. 3. Execute: c:xamppmysqlbinmysqld.exe –skip-grant-tablesc:xamppmysqlbinmysqld.exe –skip-grant-tables 4. Run another cmd.exe as administrator. 5. Execute: c:xamppmysqlbinmysql.exec:xamppmysqlbinmysql.exe 6. Execute query: UPDATE mysql.user SET Password=PASSWORD(’newpasswd’) WHERE USER=’root’;UPDATE mysql.user SET Password=PASSWORD(‘newpasswd’) WHERE User=’root’; FLUSH PRIVILEGES;FLUSH PRIVILEGES; 7. Close cmd windows. 8. Kill mysqld process …

MySQL

Restore the MySQL root user’s full privileges in Windows

1. Stop MySQL service. Run services.msc as administrator and stop it. 2. Run cmd.exe as administrator. 3. Execute: c:xamppmysqlbinmysqld.exe –skip-grant-tablesc:xamppmysqlbinmysqld.exe –skip-grant-tables 4. Run another cmd.exe as administrator. 5. Execute: c:xamppmysqlbinmysql.exec:xamppmysqlbinmysql.exe 6. Execute query: UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE USER=’root’;UPDATE mysql.user SET Grant_priv=’Y’, Super_priv=’Y’ WHERE User=’root’; FLUSH PRIVILEGES;FLUSH PRIVILEGES; 7. Close cmd windows. 8. Kill …

Linux, Sniffing, Wireshark

Run Wireshark as a user rather than root – Ubuntu

Messages from wireshark: Running as user “root” and group “root”. This could be dangerous. Lua: Error during loading: [string “/usr/share/wireshark/init.lua”]:45: dofile has been disabled To fix them and run wireshark as normal user and not as root which is very dangerous do the following: sudo chgrp adm /usr/bin/dumpcapsudo chgrp adm /usr/bin/dumpcap sudo chmod 750 /usr/bin/dumpcapsudo …

Apache, Linux

Securing Apache Part 1

The following tips are things you can do to make your apache server more secure. Before you begin to follow the tips below, locate your apache’s configuration files first. Common places for apache’s configuration files are: /etc/apache2/apache2.conf, /etc/apache2/httpd.conf and /etc/apache2/sites-enabled/000-default. Before you make any changes, MAKE BACKUP COPIES OF YOUR FILES. Here we go: 1. …