Cant't connect

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Curt Larsson
    #1

    Cant't connect

    Hi, I have a problem to connect to my local server

    After I have done:

    c:\mysql\bin>my sqld --standalone

    I try:

    C:\mysql\bin>my sql
    ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

    Whats the problem, and where can I get help.

    mvh
    Curt


    Tags: None
    • Aggro
      #2
      Re: Cant't connect

      Curt Larsson wrote:[color=blue]
      > Hi, I have a problem to connect to my local server
      >
      > After I have done:
      >
      > c:\mysql\bin>my sqld --standalone[/color]

      Is the server running? Do you see it in the process list?

        Comment

        • Aggro
          #3
          Re: Cant't connect

          Curt Larsson wrote:[color=blue]
          > Hi, I have a problem to connect to my local server
          >
          > After I have done:
          >
          > c:\mysql\bin>my sqld --standalone[/color]

          Is the server running? Do you see it in the process list?

            Comment

            • Curt Larsson
              #4
              Re: Cant't connect

              No.
              Maybe something can be wrong in my.cnf file.

              # Example mysql config file.
              # Copy this file to c:\my.cnf to set global options
              #
              # One can use all long options that the program supports.
              # Run the program with --help to get a list of available options

              # This will be passed to all mysql clients
              [client]
              #password=my_pa ssword
              port=3306
              #socket=MySQL

              # Here is entries for some specific programs
              # The following values assume you have at least 32M ram

              # The MySQL server
              [mysqld]
              port=3306
              #socket=MySQL
              skip-locking
              set-variable = key_buffer=16K
              set-variable = max_allowed_pac ket=1M
              set-variable = thread_stack=64 K
              set-variable = table_cache=4
              set-variable = sort_buffer=64K
              set-variable = net_buffer_leng th=2K
              server-id = 1

              # Uncomment the following if you want to log updates
              #log-bin

              # Uncomment the following rows if you move the MySQL distribution to another
              # location
              #basedir = d:/mysql/
              #datadir = d:/mysql/data/


              # Uncomment the following if you are NOT using BDB tables
              #skip-bdb

              # Uncomment the following if you are using Innobase tables
              #innodb_data_fi le_path = ibdata1:100M
              #innodb_data_ho me_dir = c:\ibdata
              #innodb_log_gro up_home_dir = c:\iblogs
              #innodb_log_arc h_dir = c:\iblogs
              #set-variable = innodb_mirrored _log_groups=1
              #set-variable = innodb_log_file s_in_group=3
              #set-variable = innodb_log_file _size=5M
              #set-variable = innodb_log_buff er_size=8M
              #innodb_flush_l og_at_trx_commi t=1
              #innodb_log_arc hive=0
              #set-variable = innodb_buffer_p ool_size=16M
              #set-variable = innodb_addition al_mem_pool_siz e=2M
              #set-variable = innodb_file_io_ threads=4
              #set-variable = innodb_lock_wai t_timeout=50

              [mysqldump]
              quick
              set-variable = max_allowed_pac ket=16M

              [mysql]
              no-auto-rehash
              # Remove the next comment character if you are not familiar with SQL
              #safe-updates

              [isamchk]
              set-variable = key_buffer=8M
              set-variable = sort_buffer=8M

              [myisamchk]
              set-variable = key_buffer=8M
              set-variable = sort_buffer=8M

              [mysqlhotcopy]
              interactive-timeout


              "Aggro" <spammerdream@y ahoo.com> skrev i meddelandet
              news:tPtbc.48$F j.22@read3.inet .fi...[color=blue]
              > Curt Larsson wrote:[color=green]
              > > Hi, I have a problem to connect to my local server
              > >
              > > After I have done:
              > >
              > > c:\mysql\bin>my sqld --standalone[/color]
              >
              > Is the server running? Do you see it in the process list?[/color]


                Comment

                • Curt Larsson
                  #5
                  Re: Cant't connect

                  No.
                  Maybe something can be wrong in my.cnf file.

                  # Example mysql config file.
                  # Copy this file to c:\my.cnf to set global options
                  #
                  # One can use all long options that the program supports.
                  # Run the program with --help to get a list of available options

                  # This will be passed to all mysql clients
                  [client]
                  #password=my_pa ssword
                  port=3306
                  #socket=MySQL

                  # Here is entries for some specific programs
                  # The following values assume you have at least 32M ram

                  # The MySQL server
                  [mysqld]
                  port=3306
                  #socket=MySQL
                  skip-locking
                  set-variable = key_buffer=16K
                  set-variable = max_allowed_pac ket=1M
                  set-variable = thread_stack=64 K
                  set-variable = table_cache=4
                  set-variable = sort_buffer=64K
                  set-variable = net_buffer_leng th=2K
                  server-id = 1

                  # Uncomment the following if you want to log updates
                  #log-bin

                  # Uncomment the following rows if you move the MySQL distribution to another
                  # location
                  #basedir = d:/mysql/
                  #datadir = d:/mysql/data/


                  # Uncomment the following if you are NOT using BDB tables
                  #skip-bdb

                  # Uncomment the following if you are using Innobase tables
                  #innodb_data_fi le_path = ibdata1:100M
                  #innodb_data_ho me_dir = c:\ibdata
                  #innodb_log_gro up_home_dir = c:\iblogs
                  #innodb_log_arc h_dir = c:\iblogs
                  #set-variable = innodb_mirrored _log_groups=1
                  #set-variable = innodb_log_file s_in_group=3
                  #set-variable = innodb_log_file _size=5M
                  #set-variable = innodb_log_buff er_size=8M
                  #innodb_flush_l og_at_trx_commi t=1
                  #innodb_log_arc hive=0
                  #set-variable = innodb_buffer_p ool_size=16M
                  #set-variable = innodb_addition al_mem_pool_siz e=2M
                  #set-variable = innodb_file_io_ threads=4
                  #set-variable = innodb_lock_wai t_timeout=50

                  [mysqldump]
                  quick
                  set-variable = max_allowed_pac ket=16M

                  [mysql]
                  no-auto-rehash
                  # Remove the next comment character if you are not familiar with SQL
                  #safe-updates

                  [isamchk]
                  set-variable = key_buffer=8M
                  set-variable = sort_buffer=8M

                  [myisamchk]
                  set-variable = key_buffer=8M
                  set-variable = sort_buffer=8M

                  [mysqlhotcopy]
                  interactive-timeout


                  "Aggro" <spammerdream@y ahoo.com> skrev i meddelandet
                  news:tPtbc.48$F j.22@read3.inet .fi...[color=blue]
                  > Curt Larsson wrote:[color=green]
                  > > Hi, I have a problem to connect to my local server
                  > >
                  > > After I have done:
                  > >
                  > > c:\mysql\bin>my sqld --standalone[/color]
                  >
                  > Is the server running? Do you see it in the process list?[/color]


                    Comment

                    • Aggro
                      #6
                      Re: Cant't connect

                      Curt Larsson wrote:[color=blue]
                      > No.
                      > Maybe something can be wrong in my.cnf file.[/color]

                      Have you changed it or is it original?

                      What exactly happens after you have done:

                      c:\mysql\bin>my sqld --standalone

                      Does it print any messages? Is there anything at the error.log?

                        Comment

                        • Aggro
                          #7
                          Re: Cant't connect

                          Curt Larsson wrote:[color=blue]
                          > No.
                          > Maybe something can be wrong in my.cnf file.[/color]

                          Have you changed it or is it original?

                          What exactly happens after you have done:

                          c:\mysql\bin>my sqld --standalone

                          Does it print any messages? Is there anything at the error.log?

                            Comment

                            Previous template Next
                            Working...