Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    ajthornton
    Guest
    mySQL and phpmyadmin help
    I have successfully setup phpmyadmin and mySQL of linux systems several times. I now have a macbook running mac os x 10.4.6. I am trying to get these two programs setup. I have the mysql running (i think) and i have setup the php config.include.inc script but i keep getting this error.
    Code:
    #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
    I do not think there is a root password so when i open http://localhost/phpMyAdmin i only get the error. i will post any needed information.
    Thanks in advance,
    ajthornton

  2. #2
    mySQL and phpmyadmin help
    Murlyn's Avatar
    Member Since
    Jun 11, 2003
    Location
    Mount Vernon, WA
    Posts
    4,915
    Specs:
    MacBook Pro 2.6 GHz Core 2 Duo 4GB RAM OS 10.5.2
    Did you use the OS X install from MySQL?

  3. #3
    ajthornton
    Guest
    Quote Originally Posted by Murlyn
    Did you use the OS X install from MySQL?
    I got the install from here: http://dev.mysql.com/doc/refman/5.0/...tallation.html

    And here is a snippet (the only part that I changed) of my config.inc.php file under the Library -> WebServer -> Documents -> phpMyAdmin.
    Code:
    $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';
    
    /**
     * Disable the default warning that is displayed on the DB Details Structure page if
     * any of the required Tables for the relationfeatures could not be found
     */
    $cfg['PmaNoRelation_DisableWarning']  = FALSE;
    
    /**
     * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
     * at least one server configuration uses 'cookie' auth_type, enter here a
     * passphrase that will be used by blowfish. The maximum length seems to be 46
     * characters.
     */
    $cfg['blowfish_secret'] = 'marines';
    
    /**
     * Server(s) configuration
     */
    $i = 0;
    // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
    // $cfg['Servers'][0]. You can disable a server config entry by setting host
    // to ''. If you want more than one server, just copy following section
    // (including $i incrementation) serveral times. There is no need to define
    // full server array, just define values you need to change.
    $i++;
    $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
    $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
    $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
    $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
    $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
    $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                        // (requires PHP >= 4.3.0)
    $cfg['Servers'][$i]['controluser']   = 'root';      // MySQL control user settings
                                                        // (this user must have read-only
    $cfg['Servers'][$i]['controlpass']   = '';   // access to the "mysql/user"
                                                        // and "mysql/db" tables).
                                                        // The controluser is also
                                                        // used for all relational
                                                        // features (pmadb)
    $cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
    $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
    $cfg['Servers'][$i]['password']      = '';   // MySQL password (only needed
                                                        // with 'config' auth_type)

  4. #4
    ajthornton
    Guest
    Let me try this again. I may have done something wrong. I installed the Mac OS X 10.4 (x86) version of mysql. I have installed and configured the phpmyadmin as stated earlier. I also installed the mySQL Administrator. When I open the mySQL Admin this is some of the data that I find:

    MySQL Version: MySQL 5.0.22-standard via socket
    Network Name: localhost
    IP: 127.0.0.1

    The service screen states that the server is running.
    There is an /etc/my.cnf file
    Two accounts are setup.
    username - password
    root - marines
    ajthornton - marines

    this is the full contents of the error log
    Code:
    060609 05:52:09  mysqld started
    060609  5:52:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    060609  5:52:09  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    060609  5:52:09  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    060609  5:52:09  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    060609  5:52:10  InnoDB: Started; log sequence number 0 0
    060609  5:52:10 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.0.22-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
    060609  5:54:11 [Warning] Got signal 1 from thread 1
    060609 11:41:44  mysqld started
    060609 11:41:45 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
    060609 11:41:45  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    060609 11:41:45  InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43655.
    InnoDB: Doing recovery: scanned up to log sequence number 0 43655
    060609 11:41:45  InnoDB: Started; log sequence number 0 43655
    060609 11:41:45 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.0.22-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
    060609 13:10:44 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
    
    060609 13:10:45  InnoDB: Starting shutdown...
    060609 13:10:48  InnoDB: Shutdown completed; log sequence number 0 43655
    060609 13:10:48 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
    060609 13:10:48  mysqld ended
    
    060609 19:18:00  mysqld started
    060609 19:18:00 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
    060609 19:18:01  InnoDB: Started; log sequence number 0 43655
    060609 19:18:01 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.0.22-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
    060609 19:18:57 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
    
    060609 19:18:57  InnoDB: Starting shutdown...
    060609 19:18:59  InnoDB: Shutdown completed; log sequence number 0 43655
    060609 19:18:59 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
    060609 19:18:59  mysqld ended
    
    060609 19:19:42  mysqld started
    060609 19:19:45 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
    060609 19:19:45  InnoDB: Started; log sequence number 0 43655
    060609 19:19:46 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.0.22-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)
    In the catalogs tab I can see the 3 tables (information_s, mysql, and test).

    Now when I load via web browser http://localhost/phpMyAdmin I get the following message:
    Code:
    #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
    If you know a way to fix this, please let me know, or if more information is needed. I am willing to emial my AOL chat screen name for instant chatting if that would be helpful.


    Thanks in advance,
    ajthornton

  5. #5
    komo
    Guest
    why don't you just use MAMP, instead. i found out it's as easy as Windows' AppServ

  6. #6
    ajthornton
    Guest
    Quote Originally Posted by komo
    why don't you just use MAMP, instead. i found out it's as easy as Windows' AppServ
    komo, you are a life saver. I had no trouble getting things up and running. I just have one quick question. Is there a way to access the mySQL information from the terminal? If yes, how?

    THANKS A MILLION, komo
    ajthornton

  7. #7
    komo
    Guest
    Quote Originally Posted by ajthornton
    komo, you are a life saver. I had no trouble getting things up and running. I just have one quick question. Is there a way to access the mySQL information from the terminal? If yes, how?

    THANKS A MILLION, komo
    ajthornton
    what kind of "mySQL information" do you want to access to?
    you can always access mysql from the terminal using "mysql" command line. just start the mysql service, go to /Application/MAMP/Library/bin, and typed "./mysql" without the quote.
    that will bring up the mySQL prompt and (I think) you can work with your mySQL from there. i really never used that prompt anyway, phpmyadmin is a lot easier

  8. #8
    ajthornton
    Guest
    i have figured out what you said, but I am still having some problems. When I start MAMP I see that both the apache and mysql servers are started. I can click on the phpinfo link and see the phpinfo load properly. However, when I build a php document in /Applications/MAMP/htdocs and try to access it the page comes up blank. This happens with the basic
    PHP Code:
    <?php 
    phpinfo
    (); 
    ?>
    page up to a complex script. Anyidea what is going on?


    Quote Originally Posted by komo
    what kind of "mySQL information" do you want to access to?
    you can always access mysql from the terminal using "mysql" command line. just start the mysql service, go to /Application/MAMP/Library/bin, and typed "./mysql" without the quote.
    that will bring up the mySQL prompt and (I think) you can work with your mySQL from there. i really never used that prompt anyway, phpmyadmin is a lot easier

  9. #9
    mySQL and phpmyadmin help
    Murlyn's Avatar
    Member Since
    Jun 11, 2003
    Location
    Mount Vernon, WA
    Posts
    4,915
    Specs:
    MacBook Pro 2.6 GHz Core 2 Duo 4GB RAM OS 10.5.2
    Sorry I would have responded sooner, but for some reason I was not getting notifications that there was a reply on this thread Good it sounds like you have it up and running.. hmm..

    When you look at the blank page, view source, do you see the code? or is it blank also? If you do see the code then php is not parsing the page.. if you do not see the code.. then you might have a wrong path somewhere...

  10. #10
    ajthornton
    Guest
    I do see code. I am using this MAMP. It tells me to put everything in this htdocs folder, but it does allow me to change this folder location. Does anyone know how this will work. Also, what is meant by parsing the pae. is this something that I am doing wrong. This is exactly what I see when I view the code:

    PHP Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
            <title>Using echo()</title>
        </head>
        <body>
        <?php
            phpinfo
    ();
        
    ?>
        </body>

    </html>
    Quote Originally Posted by Murlyn
    Sorry I would have responded sooner, but for some reason I was not getting notifications that there was a reply on this thread Good it sounds like you have it up and running.. hmm..

    When you look at the blank page, view source, do you see the code? or is it blank also? If you do see the code then php is not parsing the page.. if you do not see the code.. then you might have a wrong path somewhere...

  11. #11
    komo
    Guest
    Quote Originally Posted by ajthornton
    I do see code. I am using this MAMP. It tells me to put everything in this htdocs folder, but it does allow me to change this folder location. Does anyone know how this will work. Also, what is meant by parsing the pae. is this something that I am doing wrong. This is exactly what I see when I view the code:

    PHP Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
            <title>Using echo()</title>
        </head>
        <body>
        <?php
            phpinfo
    ();
        
    ?>
        </body>

    </html>
    CMIIW, but i think those codes can't be the one that showed up when you click "View Source" option on your browser. try to make a simple scripts using an echo or more, then post the source on your browser here

  12. #12
    mySQL and phpmyadmin help
    Murlyn's Avatar
    Member Since
    Jun 11, 2003
    Location
    Mount Vernon, WA
    Posts
    4,915
    Specs:
    MacBook Pro 2.6 GHz Core 2 Duo 4GB RAM OS 10.5.2
    Did you name your file something.php? or something.htm(l)? If you you named it .php then php is not parsing that page which means you need to check your apache config file. now if you named it .htm or .html then rename it to .php and it should start parsing the page IF php is enabled.

  13. #13
    ajthornton
    Guest
    what is CMIIW? here is another simple code that I have tried.

    PHP Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
            <title>Using echo()</title>
        </head>
        <body>
        <?php
            
    echo 'This is my first php script!';
        
    ?>
        </body>

    </html>
    Quote Originally Posted by komo
    CMIIW, but i think those codes can't be the one that showed up when you click "View Source" option on your browser. try to make a simple scripts using an echo or more, then post the source on your browser here

  14. #14
    mySQL and phpmyadmin help
    Murlyn's Avatar
    Member Since
    Jun 11, 2003
    Location
    Mount Vernon, WA
    Posts
    4,915
    Specs:
    MacBook Pro 2.6 GHz Core 2 Duo 4GB RAM OS 10.5.2
    Again what did you name your file? PHP is definitely not parsing your code... And that's when you view source in the browser correct?

  15. #15
    ajthornton
    Guest
    the name of the file is first.php, and yes that is what I see when view code. Here is anothe one that I tried real quick this file is names phpinfo.php
    PHP Code:
    <?php
    phpinfo
    ();
    ?>
    That is the code that I see, ehich is exacty what I typed.


    Quote Originally Posted by Murlyn
    Again what did you name your file? PHP is definitely not parsing your code... And that's when you view source in the browser correct?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. phpmyadmin installation question
    By ceport in forum OS X - Operating System
    Replies: 0
    Last Post: 02-04-2012, 08:31 PM
  2. how to import large files into mysql with phpmyadmin on mac
    By ninastitch in forum Web Design and Hosting
    Replies: 1
    Last Post: 07-20-2011, 03:34 PM
  3. phpmyadmin and folder privs
    By Pabs in forum OS X - Operating System
    Replies: 0
    Last Post: 06-18-2011, 07:02 PM
  4. PHPMYadmin
    By sammy5683 in forum OS X - Development and Darwin
    Replies: 0
    Last Post: 01-23-2009, 12:22 PM
  5. pmadb with phpMyAdmin and MAMP?
    By tobias in forum Web Design and Hosting
    Replies: 0
    Last Post: 06-29-2006, 09:29 AM

Posting Permissions

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