Welcome to Geeklog, Anonymous Monday, June 05 2023 @ 07:20 am 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?
3
3
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
Geeklog Plugins: http://plugincms.com
2
5
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.
4
5
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
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
4
3
Quote
All times are EDT. The time is now 07:20 am.
- 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