I cant make my ip address public (ubuntu server 9.10) and mysqld.sock is empty

Jamie Kugelmann · 05-12-2009, 02:48 AM

Hi all, i have just built a brand new server using ubuntu server 9.10 and ive searched EVERYWHERE and i just can't find out how to make my ip address public so everyone can view it ive done everything except i cant seem to let anyone view it. and when i go to http://192.168.1.105/phpmyadmin/ (my servers home network address) it just says: "#1045 - Access denied for user 'jamie'@'localhost' (using password: YES)" and mysqld.sock has nothing in it at all can you give me a sample mysqld.sock?

zhjim · 05-12-2009, 03:03 AM

Quote:

Originally Posted by Jamie Kugelmann

Hi all, i have just built a brand new server using ubuntu server 9.10 and ive searched EVERYWHERE and i just can't find out how to make my ip address public so everyone can view it ive done everything except i cant seem to let anyone view it.

Grats to your new server also I don't know why you want it to be public available but what so. Take look for dynamic dns services on the net. A good one I'm using is freedns.afraid.org. You need to sign up and install a client that tells the outworld of you IP.

Quote:

Originally Posted by Jamie Kugelmann

and when i go to http://192.168.1.105/phpmyadmin/ (my servers home network address) it just says: "#1045 - Access denied for user 'jamie'@'localhost' (using password: YES)" and mysqld.sock has nothing in it at all can you give me a sample mysqld.sock?

Hm a socket normaly doesn't contain any human readable data. It's for interprocess communication.
Check if you have your password right. If so. take a look at the mysql.user table and see what it sais for the user jamie. needs to have "localhost" as a host or "%".
Also recheck if your phpMyAdmin config uses the socket stated in your my.cnf. Normaly found in /etc

Jamie Kugelmann · 05-12-2009, 03:13 AM

in the file mysql.user in /etc/mysqld/mysql.user its is blank and also i need alot of explanation because im a kid (age 11) and i'll give that website a go ok get back to me as soon as possible.

Jamie Kugelmann · 05-12-2009, 03:34 AM

i still need help

zhjim · 05-12-2009, 03:45 AM

Quote:

Originally Posted by Jamie Kugelmann

in the file mysql.user in /etc/mysqld/mysql.user its is blank

I'm not quite sure what /etc/mysqld/mysql.user should contain (not familary with ubuntu). But normaly you interact with a database (what mysql is) through a client. mysql command on linux namely. (Bold words are command for the command line).

Check out the the link below to get a grib on mysql:
http://dev.mysql.com/tech-resources/...sql_intro.html

Quote:

Originally Posted by Jamie Kugelmann

and also i need alot of explanation because im a kid (age 11) and i'll give that website a go ok get back to me as soon as possible.

Good age to start with

Okay let's se what we should solve first. I think the mysql/phpMyAdmin would be nice?
If so please provide your /etc/my.cnf and the config of phpMyAdmin. (Put it in CODE block please. Button next to the php symbol). We'll go on from there.
If you feel to it try a

Code:

mysql -u jaime -p

on the command line and see what it says. Wait a minute. You did not realy set up your db did ya? Better try

Code:

mysql -u root

cause root is the default user within mysql and normaly does not have any password set. This should also hold true if you use root for phpMyAdmin login.

Jamie Kugelmann · 05-14-2009, 04:31 AM

thanks but it still strangely says: "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" and "ERROR 1045 (28000): Access denied for user 'jamie'@'localhost' (using password: YES)"
i dont know why its really annoying!

but thanks and get back to me as soon as you can ok.

zhjim · 05-14-2009, 07:08 AM

Seems like ubuntu is setting a random password for the root user. So you have to set a new one.

A short summary of steps can be found here:

http://ubuntu.flowconsult.at/en/mysq...root-password/

After going through this you should be able to connect to mysql like that

Code:

mysql -u root -p

This will ask for the password you just set in the previous steps.

estabroo · 05-14-2009, 07:30 AM

In your mysql user table do you have an entry for jamie@% that has a different password from jamie@localhost, cause it'll match that before the localhost entry.

Jamie Kugelmann · 05-15-2009, 01:59 AM

hi zhjim and sorry about the delay alright heres /etc/my.cnf:

Code:

it has nothing in it!

and heres my phpmyadmin config

Code:

<?php
/**
 * Debian local configuration file
 *
 * This file overrides the settings made by phpMyAdmin interactive setup
 * utility.
 *
 * For example configuration see /usr/share/doc/phpmyadmin/examples/config.defa$
 *
 * NOTE: do not add security sensitive data to this file (like passwords)
 * unless you really know what you're doing. If you do, any user that can
 * run PHP or CGI on your webserver will be able to read them. If you still
 * want to do this, make sure to properly secure the access to this file
 * (also on the filesystem level).
 */

/**
 * Server(s) configuration
 */
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['$
// You can disable a server config entry by setting host to ''.
$i++;

/* Read configuration from dbconfig-common */
require('/etc/phpmyadmin/config-db.php');

/* Configure according to dbconfig-common if enabled */
if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = 'localhost';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport)) {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
 $cfg['Servers'][$i]['port'] = $dbport;
    }
    //$cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    /* Optional: User for advanced features */
    $cfg['Servers'][$i]['controluser'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    $cfg['Servers'][$i]['relation'] = 'pma_relation';
    $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    $cfg['Servers'][$i]['history'] = 'pma_history';
    $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

    /* Advance to next server for rest of config */
    $i++;
}

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
//$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
//$cfg['Servers'][$i]['extension'] = 'mysql';
/* Optional: User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Optional: Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

Jamie Kugelmann · 05-15-2009, 02:11 AM

YAY im really really really really really really really really happy

that all i had to do was do my login name as root and type my password in but a really BIIIIIIIIIIIIG thanks to all of you. but i wasted my time not typing root

but i still need help on how to get my ip address public. THANKS TO YOU ALL

zhjim · 05-26-2009, 04:22 AM

Great to hear thats it's working now.

For the public IP part, go and check out http://freedns.afraid.org, or dyndns.com. A quick google with "dynamic dns" should give you some more like no-ip.com

rsciw · 05-26-2009, 06:40 AM

dyndns is nice, many routers also support dyndns with a built-in update function, sometimes also other dynanic dns providers too.