I have installed MySQL on Ubuntu but have not initialised anything yet. I want to learn it well enough to set up a simple database for my audio collection and also a simple database for work. Neither will be on-line or need high security. What is the easiest way to initialise it? Do you just run the install script (as root?) shell> cd mysql_installation_directory shell> ./scripts/mysql_install_db shell> ./bin/safe_mysqld --user=mysql & or shell> ./bin/mysqld_safe --user=mysql & if you are running MySQL 4.x. and continuing? I want to set it up for user rod to be able to experiment easily without ruining everything. Also what and tutorial GUI would you reccommend for my purposes? I see the python front-end was also installed along with MySQL and I have installed mysqlcc. Any pointers greatly appreciated Roderick Aldridge
On Tue, Jul 26, 2005 at 12:59:13AM +1200, Roderick Aldridge wrote:
Do you just run the install script (as root?)
You should be able to: aptitude update aptitude install mysql-server mysql-client Ubuntu (like Debian) supply packages to ease your installation woes. Cheers, James.
James Clark wrote:
On Tue, Jul 26, 2005 at 12:59:13AM +1200, Roderick Aldridge wrote:
Do you just run the install script (as root?)
You should be able to:
aptitude update aptitude install mysql-server mysql-client
Ubuntu (like Debian) supply packages to ease your installation woes.
Cheers, James.
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
James Clark wrote:
On Tue, Jul 26, 2005 at 12:59:13AM +1200, Roderick Aldridge wrote:
Do you just run the install script (as root?)
You should be able to:
aptitude update aptitude install mysql-server mysql-client
Ubuntu (like Debian) supply packages to ease your installation woes.
Cheers, James.
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
I installed mysql and mysql-client using synaptic but I see I didn't install the documentation, which I have since done. However it seems to be an info version of what I read on the mysql website. This looks to be just what is needed for an expert, but leaves me uncertain as to what has already been done by synaptic and what I need to do to achieve what I want. For example the installation section of the info manual says: "The basic commands you must execute to install and use a MySQL binary distribution are: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> scripts/mysql_install_db shell> chown -R root . shell> chown -R mysql data shell> chgrp -R mysql . shell> bin/safe_mysqld --user=mysql & or shell> bin/mysqld_safe --user=mysql & if you are running MySQL 4.x You can add new users using the bin/mysql_setpermission script if you install the DBI and Msql-Mysql-modules Perl modules." I think synaptic has done most or all of that and I that should go on to post-installation setup and testing, but how do you tell? There is no sign of mysql on my user menu. Do I need to add rod to the mysql user group? Rod
I think synaptic has done most or all of that and I that should go on to post-installation setup and testing, but how do you tell? There is no sign of mysql on my user menu. Do I need to add rod to the mysql user group?
It's likely that synaptic has also done post-installation tasks as well... You should be able to log in with the root mysql user and set up some initial mysql users. To make things slightly more confusing, mysql has an entirely seperate user list for itself. It certainly won't hurt to add rod to the mysql group. This would only control access to the mysql binary and its friends (mysqladmin, etc...). If the mysql port is open, and mysql is setup to listen on it, you can also connect from another machine using a mysql-client of some sort, without logging into a shell on the machine where the mysql server is located. Your mysql is probably ready to be logged into, with user root and a blank password. try mysql -u root and see what happens. You should get a couple of status lines about the server, and a prompt. In this mysql-cli you can type '\?' to get some help with commands and '\q' to quit. There are plenty of sites on the net that will guide you through making your mysql server is secure, and setting up initial users. At least just make sure to give your mysql root user a password. -- Cameron
Camster342 wrote:
I think synaptic has done most or all of that and I that should go on to post-installation setup and testing, but how do you tell? There is no sign of mysql on my user menu. Do I need to add rod to the mysql user group?
It's likely that synaptic has also done post-installation tasks as well... You should be able to log in with the root mysql user and set up some initial mysql users. To make things slightly more confusing, mysql has an entirely seperate user list for itself.
It certainly won't hurt to add rod to the mysql group. This would only control access to the mysql binary and its friends (mysqladmin, etc...). If the mysql port is open, and mysql is setup to listen on it, you can also connect from another machine using a mysql-client of some sort, without logging into a shell on the machine where the mysql server is located.
Your mysql is probably ready to be logged into, with user root and a blank password. try
mysql -u root
and see what happens. You should get a couple of status lines about the server, and a prompt. In this mysql-cli you can type '\?' to get some help with commands and '\q' to quit.
There are plenty of sites on the net that will guide you through making your mysql server is secure, and setting up initial users. At least just make sure to give your mysql root user a password.
-- Cameron
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
Thanks mysql -u root Shows it is running. Now I can get started. Rod
Also what and tutorial GUI would you reccommend for my purposes? I see the python front-end was also installed along with MySQL and I have installed mysqlcc.
For a mySQL GUI I use phpmyadmin. Note that it does need php and and a web-server to be installed also. This is because most of the mySQL servers I work with are hosted remotely though. If you are forced to work with a Windows desktop, then another one you may want to try is mysqlfront. I've not worked with it much myself, but I have a friend who recommends it. -- Cameron
Camster342 wrote:
Also what and tutorial GUI would you reccommend for my purposes? I see the python front-end was also installed along with MySQL and I have installed mysqlcc.
For a mySQL GUI I use phpmyadmin. Note that it does need php and and a web-server to be installed also. This is because most of the mySQL servers I work with are hosted remotely though.
If you are forced to work with a Windows desktop, then another one you may want to try is mysqlfront. I've not worked with it much myself, but I have a friend who recommends it.
-- Cameron
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
Thanks for the info. I don't want to install php and a webserver at this stage as it will be used locally. Learning one thing at a time is my plan. I plan to learn on Linux and set up the work database on Windows once I know it well enough. Rod
participants (3)
-
Camster342 -
James Clark -
Roderick Aldridge