Linux » sql in ubuntu

1 to 5 of 5

- CommentAuthorshreh
- CommentTimeSep 22nd 2009 edited
how to run sql in ubuntu
dont say wine i've used it its not workin
- CommentAuthorjain
- CommentTimeSep 22nd 2009 edited
@sresh

To install mysql in ubuntu 8.10 try this...

open APPLICATIONS->ACCESSORIES->Terminal
Then type this command:
+------------------------------------------------------------------------+
usr@usr-laptop:~$sudo apt-get install mysql-server
+------------------------------------------------------------------------+
press enter and then allow to install saying 'y'
when it will ask..

--->Now for starting the sql again open open APPLICATIONS->ACCESSORIES->Terminaland
then type this command:

+-------------------------------------------------------------------------+
usr@usr-laptop:~$mysql -u <username> -p
Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
+--------------------------------------------------------------------------+
now u are successfull for using the mysql

if u have any other query for this just post dude!!!

thanx !!
- CommentAuthorsanchitgulati
- CommentTimeSep 22nd 2009
he answered it perfectly...sql is just a language..u need a client to run sql..mysql is the best opensource opt available to us.
So do the above,or install LAMP on ubuntu comes with apache server , php and mysql.
- CommentAuthorshreh
- CommentTimeSep 24th 2009
hey thanx.....i've installd it
bt still not workin........i've installd it but not able to open it
ur 2nd command is not workin(mysql -u <username> -p)

i've installed mysql-query-browser
is it different from what u have told.....but its workin
- CommentAuthormage
- CommentTimeSep 24th 2009
to install mysql server on ubuntu.. just run the apt-get

$sudo apt-get install mysql-server

after that it'd prompt you for password.. enter your password..
your mysql-query-browser won't work without a mysql engine.

if it still doesn't work... the $mysql -u root -p
command..

then
try running the mysql deamon in safe mode..

$sudo pkill mysqld
$sudo mysqld_safe

and it in all you don't want to enter password.. or you haven't set it yet..
then run the mysql deamon with skip grant tables

$sudo mysqld_safe --skip-grant-tables

im not completely sure of your doubt but i guess this might help

*PS - all mysql functioning in Linux need to be done with root access.. so use sudo command with every working.

1 to 5 of 5