[Problima]Mysql

...ρύθμιση-εγκατάσταση δικτύων

Συντονιστές: adem1, the_eye

[Problima]Mysql

Δημοσίευσηαπό reaper » 22 Νοέμ 2016, 15:40

γεια σας εχω ενα προβλημα με το hosting εκανα install mysql/java που ηθελα ολα δουλευαν μια χαρα..
ηθελα να δωσο περισσοτερο max_connections στην mysql το περασα αλλα οταν εκανα restart δεν ανοιγε παλη το επαναφερα στα κανονικα αλλα τιποτα..
ετσι σκεφτηκα να κανω uninstall την mysql παλι και να κανς εγκατασταση..
ετσι ξεκινησαν ολα τα προβληματα.. τωρα οταν παω να κανω install mysql μου εμφανιζει αυτο το προβλημα ..

Κώδικας: Επιλογή όλων
johnyplexx@l2guard:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  mariadb-server-5.5:i386 mariadb-server-5.5

E: Package 'mysql-server' has no installation candidate



δεν το περναει.. μπορει καποιος να μου πει τι να κανω..
reaper
babeTUX
babeTUX
 
Δημοσιεύσεις: 7
Εγγραφή: 22 Νοέμ 2016, 15:30
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό eliasps » 22 Νοέμ 2016, 15:58

Μεταφέρθηκε στην κατάλληλη ενότητα.

Άβαταρ μέλους
eliasps
antiwinTUX
antiwinTUX
 
Δημοσιεύσεις: 4017
Εγγραφή: 16 Δεκ 2011, 22:25
Τοποθεσία: Αθήνα, Αττική
Launchpad: eliasps
IRC: eliasps
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό jsalatas » 23 Νοέμ 2016, 01:47

γιά τρεξε αρχικά ενα

Κώδικας: Επιλογή όλων
sudo apt-get update


και μετά δωσε μας το output toy

Κώδικας: Επιλογή όλων
sudo apt-cache search mysql | grep mysql
jsalatas
punkTUX
punkTUX
 
Δημοσιεύσεις: 174
Εγγραφή: 17 Ιουν 2016, 03:38
Τοποθεσία: USA
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό reaper » 23 Νοέμ 2016, 02:04

Κώδικας: Επιλογή όλων

johnyplexx@l2guard:~$ sudo apt-cache search mysql | grep mysql
akonadi-backend-mysql - MySQL storage backend for Akonadi
aolserver4-nsmysql - AOLserver 4 module: module for accessing MySQL databases
asterisk-mysql - MySQL database protocol support for the Asterisk PBX
automysqlbackup - daily, weekly and monthly backup for your MySQL database
cl-sql-mysql - CLSQL database backend, MySQL
courier-authlib-mysql - MySQL support for the Courier authentication library
cvm-mysql - Credential Validation Modules (MySQL)
dbf2mysql - xBase <--> MySQL
dovecot-mysql - secure POP3/IMAP server - MySQL support
dpm-copy-server-mysql - DPM copy server with MySQL database backend
dpm-name-server-mysql - DPM nameserver server with MySQL database backend
dpm-server-mysql - Disk Pool Manager (DPM) server with MySQL database backend
dpm-srm-server-mysql - DPM SRM server with MySQL database backend
dpsyco-mysql - Automate administration of access to mysql
dsyslog-module-mysql - advanced modular syslog daemon - MySQL support
falconpl-dbi-mysql - MySQL database abstraction layer for Falcon P.L
freeradius-mysql - MySQL module for FreeRADIUS server
gambas3-gb-db-mysql - MySQL driver for the Gambas database component
gambas3-gb-mysql - Gambas MySQL component
gmysqlcc - graphical client for managing MySQL databases
gnash-ext-mysql - GNU Shockwave Flash (SWF) player - MySQL extension
gnokii-smsd-mysql - SMSD plugin for MySQL storage backend
gsql-mysql-engine - MySQL engine for GSQL
handlersocket-mysql-5.5 - HandlerSocket plugin for MySQL 5.5
kamailio-mysql-modules - MySQL database connectivity module for Kamailio
kexi-mysql-driver - MySQL support for kexi
lfc-server-mysql - LCG File Catalog (LFC) server with MySQL database backend
libapache2-mod-log-sql-mysql - Use SQL to store/write your Apache queries logs -                           MySQL interface
libaprutil1-dbd-mysql - Apache Portable Runtime Utility Library - MySQL Driver
libclass-dbi-mysql-perl - extensions to Class::DBI for MySQL
libcrypt-mysql-perl - Perl module to emulate the MySQL PASSWORD() function
libdbd-mysql-ruby - Transitional package for ruby-dbd-mysql
libdbd-mysql-ruby1.8 - Transitional package for ruby-dbd-mysql
libdbd-mysql-ruby1.9.1 - Transitional package for ruby-dbd-mysql
libdspam7-drv-mysql - MySQL backend for DSPAM anti-spam filter
libgda-5.0-mysql - MySQL provider for libgda database abstraction library
libghc-hsql-mysql-dev - MySQL driver of the HSQL library for GHC
libghc-hsql-mysql-doc - API documentation of the hsql-mysql library for Haskell
libghc-hsql-mysql-prof - MySQL driver of the HSQL library for GHC; profiling lib                          raries
libkaya-mysql-dev - MySQL binding for kaya
libmysql++-dev - MySQL C++ library bindings (development)
libmysql++-doc - MySQL C++ library bindings (documentation and examples)
libmysql++3 - MySQL C++ library bindings (runtime)
libmysql-cil-dev - MySQL database connector for CLI
libmysql-diff-perl - module for comparing the table structure of two MySQL datab                          ases
libmysql-java - Java database (JDBC) driver for MySQL
libmysql-ocaml - OCaml bindings for MySql (runtime package)
libmysql-ocaml-dev - OCaml bindings for MySql (development package)
libmysql6.4-cil - MySQL database connector for CLI
libmysqld-pic - PIC version of MySQL embedded server development files
libnss-mysql-bg - NSS module for using MySQL as a naming service
libopendbx1-mysql - MySQL backend for OpenDBX
libpam-mysql - PAM module allowing authentication from a MySQL server
libpocomysql9 - C++ Portable Components (POCO) MySQL library
libpocomysql9-dbg - C++ Portable Components (POCO) MySQL library (debug version)
libqt5sql5-mysql - Qt 5 MySQL database driver
librdf-storage-mysql - RDF library, MySQL backend
libreoffice-mysql-connector - MariaDB/MySQL Connector extension for LibreOffice
libtime-piece-mysql-perl - module adding MySQL-specific methods to Time::Piece
libwtdbomysql-dev - MySQL/MariaDB backend for Wt::Dbo [development]
libwtdbomysql35 - MySQL/MariaDB backend for Wt::Dbo [runtime]
lighttpd-mod-mysql-vhost - MySQL-based virtual host configuration for lighttpd
lua-dbi-mysql - DBI library for the Lua language, MySQL backend
lua-dbi-mysql-dbg - DBI library for the Lua language, MySQL backend debug symbol                          s
lua-dbi-mysql-dev - DBI library for the Lua language, MySQL development files
lua-sql-mysql - luasql library for the Lua language
lua-sql-mysql-dev - luasql development files for the Lua language
mha4mysql-manager - Master High Availability Manager and Tools for MySQL, Manage                          r Package
mha4mysql-node - Master High Availability Manager and Tools for MySQL, Node Pack                          age
monodoc-mysql-manual - compiled XML documentation for the MySql.Data library
mysql-client-5.6 - MySQL database client binaries
mysql-client-core-5.6 - MySQL database core client binaries
mysql-common-5.6 - MySQL 5.6 specific common files, e.g. /etc/mysql/conf.d/my-5.                          6.cnf
mysql-mmm-agent - Multi-Master Replication Manager for MySQL - agent daemon
mysql-mmm-common - Multi-Master Replication Manager for MySQL - common files
mysql-mmm-monitor - Multi-Master Replication Manager for MySQL - monitoring daem                          on
mysql-mmm-tools - Multi-Master Replication Manager for MySQL - tools
mysql-proxy - high availability, load balancing and query modification for mysql
mysql-server-5.6 - MySQL database server binaries and system database setup
mysql-server-core-5.6 - MySQL database server binaries
mysql-source-5.5 - MySQL source
mysql-source-5.6 - MySQL source
mysql-testsuite - MySQL testsuite
mysql-testsuite-5.5 - MySQL testsuite
mysql-testsuite-5.6 - MySQL 5.6 testsuite
mysql-utilities - collection of scripts for managing MySQL servers
mysql-workbench - MySQL Workbench - a visual database modeling, administration a                          nd queuing tool
mysql-workbench-data - MySQL Workbench -- architecture independent data
mysqltcl - interface to the MySQL database for the Tcl language
mysqltuner - high-performance MySQL tuning script
ndoutils-nagios3-mysql - This provides the NDOUtils for Nagios with MySQL suppor                          t
node-mysql - MySQL client implementation for Node.js
nuauth-log-mysql - The authenticating firewall [MySQL log module]
oar-server-mysql - OAR batch scheduler MySQL server backend package
oar-user-mysql - OAR batch scheduler MySQL user backend package
opendnssec-dbg-mysql - Debug symbols for OpenDNSSEC (Enforcer with MySQL support                          )
opendnssec-enforcer-mysql - tool to prepare DNSSEC keys (mysql backend)
parser3-mysql - MySQL driver for Parser 3
pdns-backend-mysql - generic MySQL backend for PowerDNS
pennmush-mysql - text-based multi-user virtual world server with MySQL support
perdition-mysql - Library to allow perdition to access MySQL based popmaps
php-mdb2-driver-mysql - PHP PEAR module to provide a MySQL driver for MDB2
php5-mysqlnd - MySQL module for php5 (Native Driver)
php5-mysqlnd-ms - MySQL replication and load balancing module for PHP
pike7.8-mysql - MySQL modules for Pike
pinba-engine-mysql-5.5 - realtime statistics server for PHP using MySQL as a rea                          d-only interface
postfix-cluebringer-mysql - metapackage for mysql support in postfix-cluebringer
proftpd-mod-mysql - Versatile, virtual-hosting FTP daemon - MySQL module
puppet-module-puppetlabs-mysql - Puppet module for mysql
pure-ftpd-mysql - Secure and efficient FTP server with MySQL user authentication
python-mysql.connector - pure Python implementation of MySQL Client/Server proto                          col
python3-mysql.connector - pure Python implementation of MySQL Client/Server prot                          ocol (Python3)
r-cran-rmysql - GNU R package providing a DBI-compliant interface to MySQL
ratbox-services-mysql - IRC services for use with ircd-ratbox with the mysql bac                          kend
redmine-mysql - metapackage providing MySQL dependencies for Redmine
root-plugin-sql-mysql - MySQL client plugin for ROOT
roundcube-mysql - metapackage providing MySQL dependencies for RoundCube
rsyslog-mysql - MySQL output plugin for rsyslog
rt4-db-mysql - MySQL database backend for request-tracker4
ruby-dataobjects-mysql - MySQL adapter for ruby-dataobjects
ruby-dbd-mysql - Ruby/DBI MySQL driver
ruby-mysql - MySQL module for Ruby
ruby-mysql2 - simple, fast MySQL library for Ruby
spl-mysql - SPL Programming Language -- MySQL adapter
tarantool-mysql-plugin - Tarantool in-memory database - MySQL connector
tcl8.6-tdbc-mysql - Tcl Database Connectivity
tntdb-mysql4 - MySQL backend for tntdb database access library
ulogd-mysql - transitional dummy package for ulogd2-mysql
ulogd2-mysql - MySQL extension to ulogd
voms-mysql-plugin - VOMS server plugin for MySQL
voms-mysql-plugin-dbg - VOMS server plugin for MySQL - Debug Symbols
yate-mysql - MySQL support module for yate
zabbix-proxy-mysql - network monitoring solution - proxy (using MySQL)
zabbix-server-mysql - network monitoring solution - server (using MySQL)

reaper
babeTUX
babeTUX
 
Δημοσιεύσεις: 7
Εγγραφή: 22 Νοέμ 2016, 15:30
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό jsalatas » 23 Νοέμ 2016, 02:21

OK, τότε αυτό που θες είναι

Κώδικας: Επιλογή όλων
sudo apt-get install mysql-server-5.6


Δεν ξέρω αν θα έπρεπε να εχει και σκέτο mysql-server :\
jsalatas
punkTUX
punkTUX
 
Δημοσιεύσεις: 174
Εγγραφή: 17 Ιουν 2016, 03:38
Τοποθεσία: USA
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό reaper » 23 Νοέμ 2016, 02:58

το πατησα και μου εμφανισε αυτο

Κώδικας: Επιλογή όλων

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mysql-server-5.6 : Depends: libdbi-perl but it is not installable
                    Depends: mysql-client-5.6 (>= 5.6.16-1~exp1) but it is not g                                          oing to be installed
                    Depends: mysql-server-core-5.6 (= 5.6.16-1~exp1) but it is n                                          ot going to be installed
                    Depends: libaio1 (>= 0.3.93) but it is not installable
                    PreDepends: mysql-common (>= 5.5) but it is not installable
                    Recommends: mysql-common-5.6 but it is not going to be insta                                          lled
E: Unable to correct problems, you have held broken packages.

reaper
babeTUX
babeTUX
 
Δημοσιεύσεις: 7
Εγγραφή: 22 Νοέμ 2016, 15:30
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό jsalatas » 23 Νοέμ 2016, 03:09

Έχεις βάλει τίποτα extra ppas/repositories?

Επίσης ποιά εκδοση του ubuntu εχεις;
jsalatas
punkTUX
punkTUX
 
Δημοσιεύσεις: 174
Εγγραφή: 17 Ιουν 2016, 03:38
Τοποθεσία: USA
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό reaper » 23 Νοέμ 2016, 11:52

New release '16.04.1 LTS' available.

ναι οταν περασα την mysql για να μπορεσω να κανω connect απο το pc μου με navicat περασα αυτα τα command

Κώδικας: Επιλογή όλων
mysql -uroot -p123456


Κώδικας: Επιλογή όλων
create database l2rdev;


Κώδικας: Επιλογή όλων
GRANT ALL PRIVILEGES ON *.* TO 'sait'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
reaper
babeTUX
babeTUX
 
Δημοσιεύσεις: 7
Εγγραφή: 22 Νοέμ 2016, 15:30
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό reaper » 26 Νοέμ 2016, 00:48

jsalatas έγραψε:OK, τότε αυτό που θες είναι

Κώδικας: Επιλογή όλων
sudo apt-get install mysql-server-5.6


Δεν ξέρω αν θα έπρεπε να εχει και σκέτο mysql-server :\



προσπαθησα τα παντα δεν γινεται τιποτα... τωρα οταν παταω το

Κώδικας: Επιλογή όλων
sudo apt-get install mysql-server-5.6


μου εμφανιζει αυτο .

Κώδικας: Επιλογή όλων

root@l2guard:~# sudo apt-get install mysql-server-5.6
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.6 mysql-client-core-5.6
  mysql-common mysql-common-5.6 mysql-server-core-5.6
Suggested packages:
  mailx tinyca
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.6 mysql-client-core-5.6
  mysql-common mysql-common-5.6 mysql-server-5.6 mysql-server-core-5.6
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 20.6 MB of archives.
After this operation, 162 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://archive.ubuntu.com/ubuntu/ trusty/main mysql-common all 5.5.35+dfsg-1ubuntu1 [14.1 kB]
Get:2 http://archive.ubuntu.com/ubuntu/ trusty/main libmysqlclient18 amd64 5.5.35+dfsg-1ubuntu1 [593 kB]
Get:3 http://archive.ubuntu.com/ubuntu/ trusty/main libdbd-mysql-perl amd64 4.025-1 [99.3 kB]
Get:4 http://archive.ubuntu.com/ubuntu/ trusty/universe mysql-client-core-5.6 amd64 5.6.16-1~exp1 [4,084 kB]
Get:5 http://archive.ubuntu.com/ubuntu/ trusty/universe mysql-client-5.6 amd64 5.6.16-1~exp1 [5,591 kB]
Get:6 http://archive.ubuntu.com/ubuntu/ trusty/universe mysql-server-core-5.6 amd64 5.6.16-1~exp1 [4,333 kB]
Get:7 http://archive.ubuntu.com/ubuntu/ trusty/universe mysql-server-5.6 amd64 5.6.16-1~exp1 [5,839 kB]
Get:8 http://archive.ubuntu.com/ubuntu/ trusty/universe mysql-common-5.6 all 5.6.16-1~exp1 [14.9 kB]
Fetched 20.6 MB in 0s (24.6 MB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 86570 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.5.35+dfsg-1ubuntu1_all.deb ...
Unpacking mysql-common (5.5.35+dfsg-1ubuntu1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.35+dfsg-1ubuntu1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.35+dfsg-1ubuntu1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.025-1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.025-1) ...
Selecting previously unselected package mysql-client-core-5.6.
Preparing to unpack .../mysql-client-core-5.6_5.6.16-1~exp1_amd64.deb ...
Unpacking mysql-client-core-5.6 (5.6.16-1~exp1) ...
Selecting previously unselected package mysql-client-5.6.
Preparing to unpack .../mysql-client-5.6_5.6.16-1~exp1_amd64.deb ...
Unpacking mysql-client-5.6 (5.6.16-1~exp1) ...
Selecting previously unselected package mysql-server-core-5.6.
Preparing to unpack .../mysql-server-core-5.6_5.6.16-1~exp1_amd64.deb ...
Unpacking mysql-server-core-5.6 (5.6.16-1~exp1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
/usr/bin/mandb: can't write to /var/cache/man/16150: No space left on device
Setting up mysql-common (5.5.35+dfsg-1ubuntu1) ...
(Reading database ... 86770 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.6_5.6.16-1~exp1_amd64.deb ...
ERROR: There's not enough space in /var/lib/mysql/
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.6_5.6.16-1~exp1_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Selecting previously unselected package mysql-common-5.6.
Preparing to unpack .../mysql-common-5.6_5.6.16-1~exp1_all.deb ...
Unpacking mysql-common-5.6 (5.6.16-1~exp1) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.6_5.6.16-1~exp1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)


και οταν παταω..

Κώδικας: Επιλογή όλων
mysql -version

μου εμφανιζει αυτο

Κώδικας: Επιλογή όλων
root@l2guard:~# mysql -version
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)




σας παρακαλω ρε παιδια μια λυση.. προσπαθω κοντα μια εβδομαδα και δεν αντεχω αλλο..
reaper
babeTUX
babeTUX
 
Δημοσιεύσεις: 7
Εγγραφή: 22 Νοέμ 2016, 15:30
Εκτύπωση

Re: [Problima]Mysql

Δημοσίευσηαπό Th P » 26 Νοέμ 2016, 09:58

reaper έγραψε:/usr/bin/mandb: can't write to /var/cache/man/16150: No space left on device

reaper έγραψε:ERROR: There's not enough space in /var/lib/mysql/


δες εδώ: http://askubuntu.com/questions/5980/how-do-i-free-up-disk-space
Σταθερή είναι η διανομή που προσπαθείς ανεπιτυχώς να κρασσάρεις
Linux: Low┃Προγραμματισμός: No┃Αγγλικά: Good
Είμαι αναλφάβητος, ανιστόρητος και άξιος της μοίρας μου
Άβαταρ μέλους
Th P
powerTUX
powerTUX
 
Δημοσιεύσεις: 1888
Εγγραφή: 02 Μάιος 2009, 10:46
Τοποθεσία: Θεσσαλονίκη
IRC: ThP1
Εκτύπωση

Επόμενο

Επιστροφή στο Δικτύωση / Δίκτυα

cron