mysql

Hi
I managed to change my root password and logged in as root
then i did apt-get --purge remove mysql-client mysql-server
and installed again , but when iam installing by mistake
set the password , then when i tried "localhost/mysql" it says
"#1045 - Access denied for user: 'root@localhost' (Using password: YES) "
how to reset this???

 

The easiest way would be to just do again what you just did, uninstall mysql and reinstall.

At least that is what I would do.

 

I tried installing again but no use !!!! i still get same error message
"#1045 - Access denied for user: 'root@localhost' (Using password: YES) "

i also did "mysql" to check if the server is connected but it displayed

"Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 4.0.24_Debian-10ubuntu2-log

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

i Hope everything is alright till here

when i did netstat -tap it shows
tcp6 0 0 *:www *:* LISTEN 1 1221/apache2




so i tried, locate mysql.sock and locate mysqld.sock but it could'nt find those.
can anyone help me.......
any fix for this would be appreciated.

 

How did you get

What has been the exact command? Because this means you are connected to MySQL. Did you just enter "mysql" or "mysql -u root -p"? The 1st option would indicate you have not set your MySQL root pwd and the error you originally get indicates you try to access MySQL with a password.

With netstat you're looking at the wrong port. www indicates apache is listening on port 80, but mysql listens on port 3306 (default). you should see a LISTEN line with :mysql in it.

 

I got that by typng the command "mysql"


and this what my netsat report shows

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:32769 *:* LISTEN 7999/hpiod
tcp 0 0 localhost.localdo:32770 *:* LISTEN 8060/python
tcp 0 0 localhost.localdo:mysql *:* LISTEN 10233/mysqld
tcp 0 0 *:netbios-ssn *:* LISTEN 8429/smbd
tcp 0 0 localhost.localdoma:ipp *:* LISTEN 8941/cupsd
tcp 0 0 *:smtp *:* LISTEN 8314/master
tcp 0 0 *:microsoft-ds *:* LISTEN 8429/smbd
tcp 0 0 localhost.localdo:54218 localhost.localdoma:ipp ESTABLISHED8664/gnome-cups-ico
tcp 0 0 192.168.0.7:54174 cs5.msg.dcn.yahoo.:5050 ESTABLISHED8660/gaim
tcp 0 0 localhost.localdoma:ipp localhost.localdo:54218 ESTABLISHED8941/cupsd
tcp 0 0 localhost.localdo:32769 localhost.localdo:48776 ESTABLISHED7999/hpiod
tcp 0 0 192.168.0.7:54736 red.as-us.falkag.ne:www TIME_WAIT -
tcp 0 0 192.168.0.7:56410 202.54.157.152:www ESTABLISHED8688/firefox-bin
tcp 0 0 192.168.0.7:42610 jp-in-f104.google.c:www ESTABLISHED8688/firefox-bin
tcp 0 0 192.168.0.7:42606 jp-in-f104.google.c:www ESTABLISHED8688/firefox-bin
tcp 0 0 192.168.0.7:49506 202.54.157.145:www ESTABLISHED8688/firefox-bin
tcp 0 0 192.168.0.7:49504 202.54.157.145:www ESTABLISHED8688/firefox-bin
tcp 0 0 192.168.0.7:49278 80.92.83.145:www TIME_WAIT -
tcp 0 0 localhost.localdo:48776 localhost.localdo:32769 ESTABLISHED8060/python
tcp6 0 0 *:www *:* LISTEN 11221/apache2

Can please tell what exactly the problem is and what i should do now.???

 

means mysql is up-n-running. You need to assign a password to your root mysql user with something like:

Code:

mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

Also know that special character will cause the script to fail. The password of the mysql root user must not contain any special characters like these: §$%&/()"'?^<>|

 

Thanks... everything was OK when i did all that you said ..
but after doing all these when i typed "localhost/mysql/" in the URL it still giving me the same error(#1045) !!!!! why is that ???!!!!

Please help me.

 

Why would you want to do this? You cannot access mysql this way.

You need a tool like phpmyadmin. Please search the forums or consult the ispconfig installation page how to install the phpmyadmin package for ispconfig.

 

i installed php and
I already dowloaded
"phpMyAdmin-2.9.1.1-english test" and did..
"sudo tar -zxvf phpMyAdmin-2.9.1.1-english.tar.gz"
but i could not open a mysql from the URl.
why cant i do this???

 

Hi ....finally i done it ...i managed to access phpmyadmin and also created a table and its all working fine now...

all i did is ....
sudo gedit /etc/apt/sources .list
appended universe multiverse to the end of the first two lines. and..
sudo apt-get update;sudo apt-get upgrade
sudo apt-get install phpmuadmin

then typed localhost in my URL it displayed the phpmyadmin link
clicked on the link...displayed login page and entered 'root' (without ') and desired password.
its as simple as that...
now i could able to create table without any hitch.

Thanks for all your guidence bye..bye..have a nice day. .

 

Sharing folders

Hi,
I have two computers, a windows machine and a linux machine and both are in network.
I want to share/copy/modify foders & files between the two machines.I have installed samba.
Now i can only access the shared foders & files of windows in my linux machine but i cannot copy them .How can i do that.
when i type "smb://192.xxx.x.x/testsite" it just shows the folders as a link.but i want the php script that is present in the folder "testsite" to run in my linux machine.
And also i want to copy the folder.

How can i do this???