mysql

Discussion in 'General' started by sudha, Dec 29, 2006.

  1. sudha

    sudha New Member

    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: '[email protected]' (Using password: YES) "
    how to reset this???
     
  2. Craig

    Craig New Member

    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.
     
  3. sudha

    sudha New Member

    I tried installing again but no use !!!! i still get same error message
    "#1045 - Access denied for user: '[email protected]' (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.
     
    Last edited: Jan 26, 2007
  4. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    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.
     
  5. sudha

    sudha New Member

    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.???
     
    Last edited: Jan 26, 2007
  6. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    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: §$%&/()"'?^<>|
     
  7. sudha

    sudha New Member

    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.
     
  8. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    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.
     
  9. sudha

    sudha New Member

    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???
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    This wont work bevcause there is no vhost for the folder /var/www/mysql

    You will have to create a website and then install phpmyadmin into the website root direcory of this website or you use the phpmyadmin .pkg addon for ISPConfig.
     
  11. sudha

    sudha New Member

    :) 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. .:)
     
  12. sudha

    sudha New Member

    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???
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    This is not mysql related. Please make a new thread.
     

Share This Page