Lookfing for SQL Software?

amer_58 · 04-15-2005, 01:46 AM

I am wondering if anyone could help me out with finding a good SQL Software for Linux, Basically I want to practice on how to create table, edit row, delete, find... etc.

I also want it to be free if its possible.

Thanks.

Boby · 04-15-2005, 01:56 AM

Hello!

There are many databases for Linux, I recommend MySQL or PostgreSQL.

Boby

amer_58 · 04-15-2005, 07:03 AM

I am having trouble installing mysql 5, can anyone help? Is it usuall steps:

./configure
make
make install

amer_58 · 04-16-2005, 02:42 AM

I still cant get it running, if anyone knows a good link or an articel to help me out, am not even sure if i have the right pakage..

I have downloaded this file:
mysql-standard-6.0.3-beta-pc-linux-gnu-i686.tar.gz

but when I run the configure command this is what I get:

Code:

root@Admin:/usr/local/mysql# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h Admin password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
root@Admin:/usr/local/mysql# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/Admin.pid
050416 10:41:52  mysqld ended

Boby · 04-17-2005, 01:17 PM

Hi!

You must have an readme or install file after you unpack the mysql-arhive, mine is called "INSTALL-BINARY" in MySQL 4.1
Usually you install the MySQL server with these commands:

Code:

groupadd mysql
useradd -g mysql mysql
cd /usr/local
gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
cd mysql
scripts/mysql_install_db --user=mysql
chown -R root  .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &

Now set a password for root:

Code:

mysqladmin -u root password <newpassword>

To set now a "user" who's a superuser you have to do this

Code:

shell> mysql --user=root -p <root_password>

mysql> GRANT ALL PRIVILEGES ON *.* TO amer@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO amer@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

MySQL documentation

Hope this helped!
Boby

Greg Haynes · 04-17-2005, 02:12 PM

if there a reason your using a beta release? youll prolly have alot easier time with a 4.1 release or something along those lines. Making the jump to the mysql 5 is a big deal because they are attempting to have all sorts of database layer features, somewhat like PostgreSQL.

amer_58 · 04-18-2005, 07:32 AM

This is the error I get.

root@Admin:/usr/local/mysql# mysqladmin -u root password <password Here>
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

Boby · 04-18-2005, 07:59 AM

If you get this error, it means that your MySQL server is not running. Start it with the command

Code:

/path/to/mysql/bin/mysqld_safe --user=mysql &

You can copy the file "/path/to/mysql/support-files/mysql.server" to /etc/init.d/, then start, restart or stop the server from there with

Code:

/etc/init.d/mysql.server start
/etc/init.d/mysql.server restart
or
/etc/init.d/mysql.server stop

Options are "stop", "start", "restart".

Also you can set it now to start on each system boot.

Boby

amer_58 · 04-18-2005, 08:21 AM

am lost, can you go a bit further with me,

First, this is what I get:
root@Admin:/usr/local/mysql# /bin/mysqld_safe --user=mysql &
[2] 3140
root@Admin:/usr/local/mysql# bash: /bin/mysqld_safe: No such file or directory

Boby · 04-18-2005, 09:34 AM

Quote:

Originally posted by amer_58
am lost, can you go a bit further with me

Sure, that's why we're here on the forum

Quote:

First, this is what I get:
root@Admin:/usr/local/mysql# /bin/mysqld_safe --user=mysql &
[2] 3140
root@Admin:/usr/local/mysql# bash: /bin/mysqld_safe: No such file or directory

I think you have done this

Code:

cd /usr/local/mysql
/bin/mysqld_safe --user=mysql &

In this case you change directory to "/usr/local/mysql" and when you try to run the command "/bin/mysqld_safe --user=mysql &" it will try to run the command from "/bin" [root filesystem > /bin], not "/usr/local/mysql/bin". [hope you understand what I mean]

You can try one of the following:
command with full path

Code:

/usr/local/mysql/bin/mysqld_safe --user=mysql &

or you can try to "cd" to mysql folder and swith to folder "bin" inside it

Code:

cd /usr/local/mysql
bin/mysqld_safe --user=mysql &

You see in this last case we have no "/" before "bin", it will go a folder forward from the mysql folder.

Good luck!
Boby