Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 05:39 pm EDT

Geeklog Forums

MySQL Question


Status: offline

Pro-Productions

Forum User
Newbie
Registered: 12/05/06
Posts: 2
Is there a way of creating a root account within MySQL and without using the sites control panel?
 Quote

Status: offline

eg0master

Forum User
Regular Poster
Registered: 07/21/05
Posts: 73
Location:Stockholm
Yes. Add the account to the root group.
Geeklog Plugins: http://plugincms.com
 Quote

Status: offline

Pro-Productions

Forum User
Newbie
Registered: 12/05/06
Posts: 2
thanks for that suggestion. I have looked around the MySQL database but can't really find where I would need to make an entry. I am not a pro in MySQL so I will need a little more help.
 Quote

Status: offline

eg0master

Forum User
Regular Poster
Registered: 07/21/05
Posts: 73
Location:Stockholm
If you are not used to use MySQL, why do you want to mess around with it?

If you use a standard setup the groups table is called gl_groups. gl_users is tha table for your users. In those you have to find the right ids. Then add an entry in gl_group_assignments with the ight ids.

And if you really looked in your database, what did you think "gl_group_assignments" was used for?
Geeklog Plugins: http://plugincms.com
 Quote

All times are EDT. The time is now 05:39 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content