Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tickmike]

I want to run a MySQL data base on a local machine, I have installed it but cannot get past the logon screen .
Any help please on logging on and setting it up.

[roseway]

I've never got involved with mySQL, but perhaps your OS has set a default password which is different from the regular system passwords. I have a vague feeling that there's a command which you can run as root to set the mySQL password.

[silversurfer44]

The password initially for root is empty, and root is the only user at that stage. The root user is NOT the same root user of your operating system. You need to set the password your self. From  memory I think the command line is:-
mysql passwrd -u root [enter]
[enter the password of choice at the prompt]

DON'T FORGET THE PASSWORD or you will have to re-install.

Not wishing to bypass helping, but Mysql has an excellent help system on their website. You will have access to the complete manual (which is massive) online and search for the command(s) you want, with examples on how to use it/them.

[tickmike]

This is my job for tonight , but what I forgot to say that it's a GUI logon screen that comes up, I put 127.0.0.1 for the address, root = username, blank= password, hit 'Enter' It then complains that it cannot find it and gives me an option to 'ping' it and that ping seems to work ok !.

Edit ... The bit of software I'm helping to test needs an 'Apache Server' as well, Can anyone give any help on setting that up to work with the MySQL data base.

[silversurfer44]

Ah! What are you using to connect to the database to get a gui?
May I suggest you use the command line?

The command is :-
mysql -u root -p [enter]
the reply should be
Enter Password:
you press enter.

This should get you the welcome to mysql and the mysql prompt.
It could be that the server is not actually running and the above command sequence will tell you that.

[broadstairs]

Since you need bot MySQL and Apache why not install XAMPP for Linux. It makes life very easy for new users. From what I remember I did not have to do anything to make Apache and MySQL work together, since they are both servers what normally happens is that you access a php coded web page from your browser which runs the script in the apache server and it talks to the MySQL server.

I'd get XAMPP installed and working first and they take it from there with whatever it is you are testing, especially as there are extensions in say php (and from memory Perl) which allow access to MySQL and most of the stuff you are likely to need comes in XAMPP.

Stuart

[silversurfer44]

I would suggest setting mysql up first. Set it up so that it is secure before putting any sort of web interface or access to it. Even on a Linux system it can be a huge security hole as far as your data goes. It is quite easy to set up. Likewise Apache can be an even bigger security hole to a system.

[tickmike]

Ah! What are you using to connect to the database to get a gui?
May I suggest you use the command line?

The command is :-
mysql -u root -p [enter]
the reply should be
Enter Password:
you press enter.

This should get you the welcome to mysql and the mysql prompt.
It could be that the server is not actually running and the above command sequence will tell you that.
[/quote

re. " What are you using to connect to the database to get a gui? "  from 'synaptic'  MySQL-gui-tools   and           MySQL-administrator 

Your Command worked ok, so I had a look at my GUI logon and instead of 127.0.0.1    I  put 'localhost' in the address 'root' as password and hit 'Enter'
It also opened the admin panel.

re ..  "Likewise Apache can be an even bigger security hole to a system" Yes it can and I'm only running these test machines on my network at the back of a 'Hardware Firewall' which is locked down on ports. 

@ broadstairs  I did try 'Xampp' That installs ok and works, but The software I'm testing (To help Doctors and Vets around the world  ) wants to install in   /var/www/html     But 'Xampp' installs in   /opt/xampp.
I have tried to add a 'html' folder in   /var/www (there is none ! ) and have tried to add a 'Basic link' between the folders 'opt' and 'html'.
But the test software would not run.

[broadstairs]

Once you have xampp working you can modify the apache config file to point to /var/www/html as the document root and restart apache and it will serve out the files from that location. The config file is httpd.conf and just change the Document Root to /var/www/html.

Stuart

[tickmike]

Once you have xampp working you can modify the apache config file to point to /var/www/html as the document root and restart apache and it will serve out the files from that location. The config file is httpd.conf and just change the Document Root to /var/www/html.

Stuart

I tried that Stuart but no luck,  .
I have un-installed Xampp and from 'Synaptic' loaded 'task-lamp' and that works straight out of the box  .
In /var/www it installs a few more folders as well, maybe some of these are needed to run this test software.

[broadstairs]

I dont know what it is you are testing but it is a little worrying if it has to have a particular directory structure above Document Root in apache. If this is something the users will have to install on their system, unless it is a complete turnkey solution, it will have to cope with many different directory structures.

Stuart

[tickmike]

Good point, I will ask some questions, As far as I know the doctor I,m helping wants to get this software ( to be made open source) to run on PCLinuxOS so he can make / get copy's made to give out free to other doctors and vets in his country.

The good news is that I've had it running ok by using 'Lamp' installed via the package manager.

Edit.. Running his test software tonight, It sets up 'users' in MySQL data base and configures MySQL and Apache settings for safe working.