Apache Friends Support Forum

When i go to the security page it wont let me change the superuser which is Root to a different name cos i think some one might know my password and it would be less worrying if the user name was not root lol

I maanged to change one login username which was for xampp but if i go to the myadmin its always root as username which i dont know how to change

how to change superuser "root"

I hope to be correct - I have done this already one year ago
maybe I failed to remember to one or two points
if you will find a mistake, please let me know
thank you


A

stop Apache and services



B

make renamed backups of

/mysql/data/mysql/user.MYD
/mysql/data/mysql/user.MYI

example

/mysql/data/mysql/user_MYD.txt
/mysql/data/mysql/user_MYI.txt



C

delete

/mysql/data/mysql/user.MYD
/mysql/data/mysql/user.MYI
/mysql/backup/mysql/user.MYD
/mysql/backup/mysql/user.MYI



D

edit

/mysql/share/mysql_system_tables_data.sql

change "root" in the the lines

INSERT INTO tmp_user VALUES ('localhost','root','','Y','Y', ...
REPLACE INTO tmp_user VALUES (@@hostname,'root','','Y','Y', ...
REPLACE INTO tmp_user VALUES ('127.0.0.1','root','','Y','Y', ...

with "your_new_superuser_name"



E

edit

/apache/conf/extra/httpd-xampp.conf

change "root" in the the line

AuthMySQLUser root

with "your_new_superuser_name"

comment out this line by a #

# AuthMySQLUser your_new_superuser_name

otherwise your_new_superuser_name will take effect too early



F

edit

if used .htpasswd and .htaccess files or create new files



Note,
there are more preset superuser names (not "root"), e. g. in Mercury



G

start Apache and services (they should run without user and password)

include the edited

/mysql/share/mysql_system_tables_data.sql

in mySQL



H

stop Apache and services



I

edit

/apache/conf/extra/httpd-xampp.conf

uncomment the line

# AuthMySQLUser your_new_superuser_name

now your_new_superuser_name might take effect



J

restart Apache and services

to let take effect your_new_superuser_name



K

if your system should work,

delete the renamed backups of

/mysql/data/mysql/user.MYD
/mysql/data/mysql/user.MYI

and



L

delete or modify

/mysql/resetroot.bat

take care!
in case you will run it,
it will install again superuser root




done