XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / Reset Admin username or ability to change it
Register
1
starduster
Reset Admin username or ability to change it

  • 2005/10/5 16:12

  • starduster

  • Just popping in

  • Posts: 24

  • Since: 2005/10/5


I am wondering if the is any way to edit the admin username in the MySQL database.

For instance say it was count dracula, i want to rename it to CoUnT dRaCuLa.

All i am asking is were is its location in the database, it will save me doing a clean install.

Thanks and hi.
2
bluenova
Re: Reset Admin username or ability to change it

You can do it from within xoops

System admin > Edit users > find your username > edit user > change the username
3
starduster
Re: Reset Admin username or ability to change it

  • 2005/10/6 15:57

  • starduster

  • Just popping in

  • Posts: 24

  • Since: 2005/10/5


I have tried that before i posted thanks but all i get User name already exists.

That was why i posted about the sql location so i could change it manually, i done same sort of thing in postnuke db in past to reset the admin account, maybe that is what i should have asked how do i reset admin account to make a new one.

I will search the forums again and faq hopefully something will pop up.
4
JMorris
Re: Reset Admin username or ability to change it

  • 2005/10/6 17:54

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


In the xoopsprefix_users table, edit the uname field.

Hope this helps.

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.
5
starduster
Re: Reset Admin username or ability to change it

  • 2005/10/6 19:22

  • starduster

  • Just popping in

  • Posts: 24

  • Since: 2005/10/5


Thanks works a treat , I also found another way to do it, I backed up the database then edited the users.sql via notepad and re entered it back into the Database.

Good cms this XOOPS is, i was suprised how flexible it seems to others like postnuke, mambo etc

Anyway, thanks again
6
bluenova
Re: Reset Admin username or ability to change it

It's because the system doesn't recongnise caps and small letters, another way would be to change the name to something else, then change it back to the old name but with caps
7
starduster
Re: Reset Admin username or ability to change it

  • 2005/10/6 20:26

  • starduster

  • Just popping in

  • Posts: 24

  • Since: 2005/10/5


I didnt know about the not noticing caps but i think when i activated my install i typed the admin username lower case and then thought, erm, i shouldnt have done that

Anyway, im pretty pleased this thread is resolved and i got my alternating lower/uppercase admin username that i wanted and a few ways to resolve the problem, Cheers
8
JMorris
Re: Reset Admin username or ability to change it

  • 2005/10/6 21:25

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


Actually, whether the system recognizes character case or not is dependant on the database configuration. I have the database configured on one site for case sensitivity, for security reasons.

Best Regards,

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.
9
starduster
Re: Reset Admin username or ability to change it

  • 2005/10/7 18:11

  • starduster

  • Just popping in

  • Posts: 24

  • Since: 2005/10/5


I am quite interested in how to apply the case sensitivity, especially for passwords, How can i apply this, if you dont mind sharing that information.
10
JMorris
Re: Reset Admin username or ability to change it

  • 2005/10/7 23:42

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


Basically, you have to change the collation settings for MySQL.

In my case, the native language of our visitors is english; therefore, I set the default collation of the database to latin1_general_cs. The _cs indicates the the character set is case sensitive. I modified our existing database tables to accept the new character set using the following MySQL query string on each table.

ALTER TABLE CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_cs;

Now, when I try to log in with firstname.lastname instead of Firstname.Lastname, I get incorrect login. It's only when I match the case of the original username (in this case Firstname.Lastname) that I can login.

You can find more information on collation and case sensitivity in databases in the MySQL Documentation.

Hope this helps.

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

392 user(s) are online (63 user(s) are browsing Support Forums)

Members: 0

Guests: 392

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits