http://www.wiki.tuturutu.eu/ 2026-04-15T22:38:09+00:00 http://www.wiki.tuturutu.eu/ http://www.wiki.tuturutu.eu/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2016-02-12T07:33:40+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.wiki.tuturutu.eu/doku.php?id=wamp:mysql:connect_to_mysql&rev=1455262420&do=diff Connect to MySQL server Connect to MySQL server mysql -u root -p Connect to remote MySQL server mysql -h hostname -u username -p text/html 2016-02-12T07:36:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.wiki.tuturutu.eu/doku.php?id=wamp:mysql:intro&rev=1455262606&do=diff MySQL * MySQL set password * Connect to MySQL Server * SQL statements implemented in MySQL text/html 2016-02-12T07:00:24+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.wiki.tuturutu.eu/doku.php?id=wamp:mysql:set_pass&rev=1455260424&do=diff Set password to MySQL server “BUILD YOUR OWN DATABASE DRIVEN WEB SITE USING PHP & MYSQL” BY KEVIN YANK 4th edition mysqladmin -u root status When you hit Enter you should see a line or two of basic statistics about your MySQL server, like this: text/html 2016-02-12T07:51:28+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.wiki.tuturutu.eu/doku.php?id=wamp:mysql:sql_statements&rev=1455263488&do=diff SQL Statements Implemented in MySQL Alter Table ALTER [IGNORE] TABLE tbl_name action[, action …] In this code, action refers to an action as defined below. ALTER TABLE queries may be used to change the definition of a table without losing any of the information in that table (except in obvious cases, such as the deletion of a column). Here are the main actions that are possible: