Welcome to Geeklog, Anonymous Wednesday, November 29 2023 @ 04:47 am EST
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
3
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.
5
6
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
5
4
Quote
All times are EST. The time is now 04:47 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