Results 1 to 7 of 7

Thread: Why can't my DA make any new phpmyadmin databases?

  1. #1
    Join Date
    Jul 2011
    Posts
    37

    Why can't my DA make any new phpmyadmin databases?

    Accessing from DirectAdmin, in MYSQL I create a new database, but when it comes to phpmyadmin, this user and this database can't appear. Why could this be?

    The MYSQL is at User Level, because it seems like thats the only possible level, as reseller and admin level don't even mention MYSQL.

    And why do all the usernames and databases have to have ''admin'' preceding them?

  2. #2
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    11,023
    Quote Originally Posted by jiri2 View Post
    Accessing from DirectAdmin, in MYSQL I create a new database, but when it comes to phpmyadmin, this user and this database can't appear. Why could this be?
    As what user do you access phpMyAdmin? You should access it either as superuser (da_admin/root) or as owner of the database (with credentials of newly created MySQL DB).

    Quote Originally Posted by jiri2 View Post
    The MYSQL is at User Level, because it seems like thats the only possible level, as reseller and admin level don't even mention MYSQL.
    You can access it as root and da_admin (these two users have the all possible privileges to deal with MySQL).

    Quote Originally Posted by jiri2 View Post
    And why do all the usernames and databases have to have ''admin'' preceding them?
    If you create databases as user admin in directadmin then it's how it should be, as all databases and mysql usernames contain username_ (admin_) as prefix.
    With regards, Alex.

    Professional Server Management for web hosting companies and individuals
    Hourly Support, Disaster Recovery, Server Hardening, Monthly Subscription
    Directadmin installation and optimization

    Click here if you need a Linux Admin

  3. #3
    Join Date
    Jul 2011
    Posts
    37
    Quote Originally Posted by zEitEr View Post
    As what user do you access phpMyAdmin? You should access it either as superuser (da_admin/root) or as owner of the database (with credentials of newly created MySQL DB).
    I access it as ''admin''. Is that da_admin?

    Also I can't remember where but I seem to have created one database that works, just can't create anymore and it's really frustrating. Makes no sense, the database claims to have been made in DA but I go to phpmyadmin and it's just not there. In phpmyadmin there isn't an option to create a database.

  4. #4
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    11,023
    User "admin" of MySQL is a regular user, having no privileges to access databases of other users. You should login either as da_admin or root user.

    Related to http://www.site-helper.com/mysql.html
    With regards, Alex.

    Professional Server Management for web hosting companies and individuals
    Hourly Support, Disaster Recovery, Server Hardening, Monthly Subscription
    Directadmin installation and optimization

    Click here if you need a Linux Admin

  5. #5
    Join Date
    Jul 2011
    Posts
    37
    nvm i was logging in into phpmyadmin precisely as the db user I'd created but the password had been saved in firefox so i forgot

    thanks

  6. #6
    Join Date
    Sep 2011
    Posts
    56
    I cannot access phpmyadmin at all. my DA admin and my root user and passwords do not work for it! Any help?

  7. #7
    Join Date
    Oct 2004
    Location
    London, UK
    Posts
    6,641
    If directadmin and mysql level doenst give connection error so the password is stored in /usr/local/directadmin/conf/mysq.conf

    If neither directadmin can log into mysql with da_admin username you should try this guide: http://help.directadmin.com/item.php?id=45

    Regards
    SeLLeRoNe - Andrea Iannucci
    DevOps Engineer - System Administrator
    If you need my support write me an E-Mail to Support@CrazyNetwork.it

Similar Threads

  1. Users not able to see databases in PhpMyAdmin after change_username.sh
    By sullise in forum General Technical Discussion & Troubleshooting
    Replies: 6
    Last Post: 05-10-2011, 06:37 AM
  2. phpmyadmin has wrong databases
    By csw in forum User-Level Difficulties
    Replies: 1
    Last Post: 01-03-2011, 06:31 AM
  3. All databases visible in phpMyAdmin
    By Line Yoble in forum Admin-Level Difficulties
    Replies: 6
    Last Post: 10-14-2009, 10:13 AM
  4. phpmyadmin user databases
    By Guti in forum MySQL / PHP
    Replies: 1
    Last Post: 11-14-2005, 11:09 AM
  5. phpmyadmin seeing all databases
    By RackSystems in forum MySQL / PHP
    Replies: 3
    Last Post: 05-07-2005, 05:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •