How to connect from windows command prompt to mysql command line

The cd in your question is invalid 

cd CD:\MYSQL\bin\

You can't cd to CD:\ anything, because CD:\ isn't a valid directory in Windows. CD: would indicate a drive, except that drives are restricted to a single letter between A and Z. 

If your \MYSQL\BIN is on drive C:, then your commands need to be:

C:\>cd \MYSQL\Bin

C:\MYSQL\Bin>mysql -u root -p admin

-

If you're not already on C: (which you'll know by looking at the prompt in the cmd window), or your MySQL folder is on another drive (for instance, D:), change to that drive too:

C:\> cd /d D:\MYSQL\Bin

D:\MYSQL\Bin>mysql -u root -p admin

-

The .exe after mysql is optional, since .exe is an executable extension on Windows. If you type mysql, Windows will automatically look for an executable file with that name and run it if it finds it.

How to install phpmyadmin on ubuntu 14.04

How to install phpmyadmin on ubuntu 14.04

Phpmyadmin is a free web tool used to administrative MySQL database. You can perform all major tasks like creating ,

1. Apache2 installation

sudo apt-get update


2. Mysql installation 

sudo apt-get install phpmyadmin



"During the installation, You will prompted to choose the type of web server . just choose “apache2″."

Now you will be prompted for mysql database configuration, just choose “No” as we already configured mysql server manually and hit enter to complete the installation 

open the path “http://localhost/phpmyadmin” in the browser , you will prompted for username and password . just type Mysql root username and password given during the Mysql installation

If you are getting “Page not found” issue .Include the below line in /etc/apache2/apache2.conf file.

" Include /etc/phpmyadmin/apache.conf "

after that command

sudo /etc/init.d/apache2 restart 


Enjoy :)


if there is an ISSUE in password then 

click here 

install LAMP in ubuntu (Linux)

LAMP is used to create web project in linux 14.4



LAMP 

Linux Apache MySql Phpmyadmin

use the basic 6 step and Enjoy :)

1. Install Apache

sudo apt-get install apache2

2. Install MySQL

To install MySQL you must install the Metapackage mysql-server. This can be done by searching for and installing in the Software Centre, or by running the following command.

sudo apt-get install mysql-server

3. Install PHP

install the Metapackages php5 and libapache2-mod-php5.sudo apt-get install php5 libapache2-mod-php5

4. Restart Server

sudo /etc/init.d/apache2 restart

5. Check Apache

Open a web browser and navigate to http://localhost/. You should see a message saying It works!

6. Check PHP

php -r 'echo "\n\nYour PHP installation is working fine.\n\n\n";'

Congratulations, you have just Installed a Ubuntu LAMP Server!