PhpMyAdmin User problems through DirectAdmin

S

Steveinid

New member
Joined
Mar 6, 2023
Messages
5
I signed up with a web host recently and they've been great. However, I ran into a problem that they don't seem to understand.

I can only access PhpMyAdmin through the DirectAdmin panel. I click on the link and it takes me there and that is it. Simple.
When I try to upload a file to a table in the Database I created, it gives me an error and tells me that I don't have permissions
to upload the file. So I look to see who I am logged into PhpMyAdmin as and I'm logged in as some random user. Not a user
I created. The latest user is "User: da_sso_GpkAKxemN@localhost ".

I've searched the forum and I've not found a definitive answer on what is happening. At the moment I can't populate my database
with the files on my computer because the "User" doesn't have the correct permissions. How do I correct this problem?

Any help would be great.
 
Hello,

Will it work if you try to import a DataBase in DirectAdmin?

MySQL Management -> Upload Backup

database_backup.png
 
It seems to... It allows me the option to do so and it allows me the option to create a database... but I don't think this will help.

I'm trying to load a .csv file directly into a table through PhpMyAdmin. That is where my permissions problem is. Also... in PhpMyAdmin
I am unable to create a database as I have no permissions to do so with the SSO random/temporary user.

I found a bit more on the subject of SSO users. Or... Single Sign-On users here: Direct Admin SSO Feature
 
If LOAD DATA INFILE is disabled in MySQL server, then there is nothing you can do but change a hosting provider or migrate to a VPS.
 
LOAD DATA INFILE is exactly what I'm trying to do. I have been going back and forth with my host provider. They don't seem to know much about any of this. I've been thinking if this doesn't get resolved in the next couple of days then i'll find another host. Any suggetsions? I don't want to go through this again. I'm considering HostGator.

Thanks for your replies.
 
I don't sell shared hosting, but there are users on the forums who sell shared hosting accounts. You might check it with them.
 
So... Here's a little update. I had originally signed up under the most basic of plans. Very restricted I'm assuming. After a little back and forth they suggested I upgrade to the VPS. Sounds good I said if that will solve the problem.

They upgraded me and I signed into DirectAdmin. I have a different DA dashboard. I went to the MySql Management section and created a database and user for the database. I check and my user has ALL PRIVELEGES except 'grant'. I clicked on the PhpMyAdmin link and was signed on automatically with a user like: User: da_sso_zj78zwklJ@localhost. I logged out and was taken to a PhpMyAdmin login page where I logged in with newly created user and pass and am now shown as logged in as User: admin_user@localhost. GREAT... I'm now logged in as the user I created. I click on 'Databases' tab and click on 'Check Privileges' for my new database and... No privileges. WTH.

Am I missing something?

Getting frustrated.
Thank You
 
All privileges are set in DA panel. All privileges (except grant) are checkmarked for user admin_user for database admin_dbase. It just doesn't seem to be carrying over.
 
Steveinid said:
Am I missing something?
Click to expand...


The page you are trying to see as a regular user is available only for administrators. It will list users who have permissions to access a database. A regular user has no permissions to perform this action.

If for any reason you need to access it you will need to use an administrator account such as "da_admin" or "root".

See https://docs.phpmyadmin.net/en/latest/privileges.html for more information,
 
You must log in or register to reply here.
Back
Top