Command line access to mysql for addons-dev.allizom.org

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: kumar, Assigned: sheeri)

Tracking

Details

I'd like to get command line access to the MySQL db for addons-dev.allizom.org if possible. I am kmcmillan on khan's mysql server.

Using phpmyadmin is so slow it's painful :( Plus it's way easier to work in the command line.

...hopping on the bug 527475 bandwagon.
Assignee: desktop-support → server-ops-database
Component: Server Operations: Account Requests → Server Operations: Database
QA Contact: mrz → cshields
(Assignee)

Updated

6 years ago
Assignee: server-ops-database → scabral
(Assignee)

Comment 1

6 years ago
I have created the kmcmillan user on the addons-dev db with the same authentication information as on the khan mysql server.  I gave the user all permissions on the addons_dev database.

Please reopen if this does not meet your needs.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Thanks Sheeri. Now I'm trying to get access to that host in bug 713723
Hi Sheeri. We now have access to dev1.db.phx1 from mpt-vpn (bug 713723) but I can't connect to mysql. The error I get is 'Access denied for user 'kmcmillan'@'<ip_address>' (using password: YES)' so maybe you created my account for localhost only? I don't have ssh access to dev1.db.phx1.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Assignee)

Comment 4

6 years ago
Kumar - can you find me on IRC ("sheeri") and let me know what that IP is?  That way I can change the grant appropriately.
(Assignee)

Comment 5

6 years ago
Got the IP, and changed the grant to use that IP.
Status: REOPENED → RESOLVED
Last Resolved: 6 years ago6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.