Uncategorized

MySQL Server administration/basic commands/quick reference

Mysql Server Password Login to mysql server for the first time without a password root@ubuntu:~# mysql –u root Set a new password for root in mysql server  root@ubuntu:~# mysqladmin -u root  password ‘secret_password’ login to mysql with a password root@ubuntu:~# mysql –u root –p Enter the password when prompted Manage database in mysql server List all the databases… Continue reading MySQL Server administration/basic commands/quick reference