Results 1 to 7 of 7

Thread: access to phpmyadmin without passwd - not possible on os 13.1

  1. #1

    Default access to phpmyadmin without passwd - not possible on os 13.1

    have installed phpmyadmin on opensuse version 13.1

    want to have acces to login without passwd


    You either have to change the root password in mysql, or allow an empty root password in line 100 in /etc/phpMyAdmin/config.inc.php:


    i set the config accordingly

    line 92
    Code:
    // MySQL user
    $cfg['Servers'][$i]['user']                = 'root';
    
    // MySQL password (only needed with 'config' auth_type)
    $cfg['Servers'][$i]['password']            = '';
    
    // Allow access without password
    $cfg['Servers'][$i]['AllowNoPassword']     = true;
    
    // whether to allow root login
    $cfg['Servers'][$i]['AllowRoot']           = true;
    
    // Session to use for 'signon' authentication method
    $cfg['Servers'][$i]['SignonSession']       = '';
    cannot access with the following:

    use root
    pass empty


    what to do
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  2. #2

    Default AW: access to phpmyadmin without passwd - not possible on os 13.1

    Quote Originally Posted by dilbertone View Post
    have installed phpmyadmin on opensuse version 13.1

    want to have acces to login without passwd


    You either have to change the root password in mysql, or allow an empty root password in line 100 in /etc/phpMyAdmin/config.inc.php:
    That should be enough.

    But is your mysql root password really empty?
    Or did you change it?

    If root does need a password case you _cannot_ log in to phpMyAdmin without a password of course.

    Can you connect with "mysql -u root"?

  3. #3

    Default Re: access to phpmyadmin without passwd - not possible on os 13.1

    hello dear wolfi


    many many thanks for the quick answer.

    according this thread

    https://forums.opensuse.org/showthre...mysql-password

    i have the following options - note; this results are not an output of my work - i only have had a look a the methods and ways i can go...

    The normal way of setting a password for mysql does not work on opensuse 11.0

    Code:
        localhost:/etc # mysqladmin -u root password xxx
        mysqladmin: connect to server at 'localhost' failed
    see the following .,,,,
    Code:
      error: 'Access denied for user 'root'@'localhost' (using password: YES)'

    Suse is using some strange /etc/my.cnf file which has the following section
    # The following options will be passed to all MySQL clients
    [client]
    #password =xxx
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    Using this password entry changes the "password: YES" or "password: NO" answer.
    Now I am totally lost on configuring mysql and doing such simple tasks as setting of root password.
    Any help appreaciated, also any introduction into the how and why suse does it the way it works (which is different to usually).

    again - not my results and findings - but i thought that this above mentioned thread is useful.


    see another interesting thead

    http://www.cyberciti.biz/faq/how-to-...-line-and-php/


    accordin this thread i did use the following code in terminal

    Code:
        
    $ mysql -u martin -h localhost -p
    
    
    mysql -u martin -h localhost -p
    Enter password: 
    ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using password: YES)
    well - you see that i need to do something. there __ must ___ be a root passd for the mysql-db

    how to change / how to procceed now?

    look forward to hear from you
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  4. #4

    Default Re: access to phpmyadmin without passwd - not possible on os 13.1

    Quote Originally Posted by dilbertone View Post
    hello dear wolfi


    many many thanks for the quick answer.

    according this thread

    https://forums.opensuse.org/showthre...mysql-password

    i have the following options - note; this results are not an output of my work - i only have had a look a the methods and ways i can go...
    Well, I hope you do realize that this thread is from 2008?
    Not all details there might still be appropriate.

    accordin this thread i did use the following code in terminal

    Code:
        
    $ mysql -u martin -h localhost -p
    
    
    mysql -u martin -h localhost -p
    Enter password: 
    ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using password: YES)
    Hm?
    Do you actually have a _mysql_ user named "martin"?
    Try root as I said. If the password is empty, you can omit that "-p", that option tells mysql to ask for a password.

    MySQL DOES NOT automatically import the system's users. On a default openSUSE installation, there's only "root" with an empty password.

    well - you see that i need to do something. there __ must ___ be a root passd for the mysql-db

    how to change / how to procceed now?
    Well, as I said, you probably have setup a password for root, but the things that you posted here don't tell anything.
    Please run this, as I said before, and post the output:
    Code:
    mysql -u root
    And again, if you setup a password for root (or any other user as which you try to log on), you _have_ to enter the password in phpMyAdmin. There's no way around that (that's the whole point of setting up a password, isn't it?).
    Last edited by wolfi323; 31-May-2014 at 08:38.

  5. #5

    Default Re: access to phpmyadmin without passwd - not possible on os 13.1

    hello dear Wolfi

    thanks for the hints...

    this works for me

    Code:
    mysql -u root -h localhost -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 9
    Server version: 5.5.33-MariaDB openSUSE package
    
    Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]>
    welll now i know.

    the access to the db is with

    user root
    passwd: the passwd for the root user on the machine.

    guess that we subsequently can move aehead with our question of access for the phpmyadmin - can ´t we?

    look forward to hear from you
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  6. #6

    Default Re: access to phpmyadmin without passwd - not possible on os 13.1

    Quote Originally Posted by dilbertone View Post
    welll now i know.

    the access to the db is with

    user root
    passwd: the passwd for the root user on the machine.

    guess that we subsequently can move aehead with our question of access for the phpmyadmin - can ´t we?
    The same username/password that works for mysql should also work for phpMyAdmin.

  7. #7

    Smile Re: access to phpmyadmin without passwd - not possible on os 13.1

    hello dear Wolfi

    Quote Originally Posted by wolfi323 View Post
    The same username/password that works for mysql should also work for phpMyAdmin.

    many thanks - your right now it runs like a charme ;-)


    have a great day
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

Posting Permissions

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