How to use config generator script to get my config.inc.php file?
What did you mean by that?

Can I add the line here?

/
 First server
/
$i++;
/ Authentication type /
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/ Server parameters /
$cfgPmaAbsoluteUri = 'http://localhost/phpMyAdmin/'; <--- insert here?
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/ Select mysqli if your server has it /
$cfg['Servers'][$i]['extension'] = 'mysql';
/ User for advanced features /
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/ Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/
 End of servers configuration
*/

    in your phpmyadmin folder, there should be a folder called "scripts" and inside there should be an install or configuration script. It relies upon you creating a directory "config" so that it can save the configuration for you, but that's not entirely required.

    Anyway, point your browser to that install script, and then add the server you want fiddling with the items you want. Then either save the file or download it and upload to your phpmyadmin server. If you save the file on the server, make sure you move it to the correct spot (phpmyadmin root).

    I'll refer you to phpMyAdmin's documentation for further reading.

      Ok.
      Thanks for the info. 😛

        SQLyog is a nice program for managing mysql databases. It's free, and much better than using PHPmyadmin IMO

          Or you could use MySQL's own cluster of software to do things like MySQL Query Browser, MySQL Admin and MySQL Workbench....

            14 days later

            Ok.
            I go try it out.
            Thanks for the tips.

            Reply for user - foyer

            Ok.
            I go try it out.
            Thanks for the tips.

            Reply for user - bpat1434

              I'm a database n00b myself and was wondering if PDO uses mysqli_ functions, I've read this is more desired with PHP5. And since I'm learning databases, I'm going to use PHP5 and not old crusty PHP4 like i do with non-database sites. That way I can use newer and better functions and not have to relearn stuff.

                I'm not 100% sure about that. PDO is more of an object-oriented database interaction technique while mysqli is procedural. I can't be 100% sure to say that PDO doesn't use mysqli, but I'm going to say no because it includes mysql 3 support. But PDO does give you similar functionality to mysqli in that you can "prepare" and "execute" statements rather than just querying the database.

                So depending on whether you want to eventually add database systems (PostgreSQL, MSSQL, IBM DB2, etc.) to your application, helps make the determination about whether to use PDO or mysqli. If you're using only MySQL and have no plans to add any other RDBMS, use the mysqli functions. If you think you "might" (or do actually plan on) including other RDBMSes, use the PDO.

                Hope that helps.

                  it helps but I keep reading PDO is more secure than mysqli_, so I'm not sure what to use.

                    I haven't read anything like that. The only way I could see PDO being more secure is.... no... mysqli allows "transactions" which can be reverted... so no, I can't see how it's more secure. Maybe because PDO automatically escapes things for you (not 100% sure about that)?

                    To put it rather bluntly, your application is only as secure as you make it. You could be using the worlds most secure RDBMS with the most impenetrable communication layer (PDO or mysqli), but if you don't code for security, it doesn't matter.

                    You might want to read this blogger's post and the comments that follow. Supporters of both sides chime in and it's fairly interesting. Nothing on security, but like I said, it's only as secure as you make it 😉

                    Jacob Santos &#187; Blog Archive &#187; MySQL Vs PDO Updated

                      3 years later
                      fr5nz;10838386 wrote:

                      I seen examples from the net using PHPMyAdmin to create database.
                      I also learn how to create a database using MySQL Query Browser.
                      But I don't know how to create a website application to display the database I have created.
                      Do I use Dreamweaver to create the website application?
                      I'm kinda confused.
                      Can anyone give me a helping hand by giving me an idea?
                      Thanks. 🙂

                      You can use dbForge Studio for MySQL that gives you an opportunity to solve many tasks during development.

                      Also, check mysql query builder included in this dbForge Studio for MySQL

                        Write a Reply...